/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

8 votes330 views1 answer
Oracle add datafile to tablespace
SQL
0 vote293 views1 answer
Mysql autoincrement valor inicial
SQL
1 vote306 views1 answer
Postgresql delete cascade
SQL
1 vote306 views1 answer
DATE_SUB postgres
SQL
15 votes299 views2 answers
Sql order by multiple columns
SQL
0 vote315 views1 answer
Sql shell psql cannot enter password
SQL
9 votes336 views2 answers
Nosql databases
SQL
4 votes252 views1 answer
And or sql order of operations
SQL
2 votes326 views1 answer
Sql server current date minus 5 years
SQL
104 votes508 views2 answers
Like in mysql
SQL