/SQL/Psql store procedure-return multiple table values

Psql store procedure-return multiple table values

CREATE OR REPLACE FUNCTION get_production_deployment(appId integer)
  RETURNS TABLE(empId INTEGER, empName VARCHAR, designation VARCHAR) AS
$
BEGIN
 RETURN QUERY
 
 SELECT employee.id, employee.name, employee.designation
 FROM employee where employee.id = 
 (SELECT empId FROM prod_movement where prod_movement.appId = appId)

END; $
 
LANGUAGE plpgsql;

Source: pynative.com

Similar codes

0 vote237 views1 answer
FindAllBy
SQL
11 votes274 views4 answers
Round in sql
SQL
0 vote282 views2 answers
Plsql regex match whole word
SQL
0 vote307 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes269 views1 answer
Query to find table size in oracle 12c
SQL
4 votes332 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote481 views1 answer
Get first match in each group mysql query
SQL
0 vote285 views1 answer
Drop procedure sql
SQL
0 vote287 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote265 views1 answer
Mysql get 2nd value in comma separated list
SQL