/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 vote170 views1 answer
Db format in quotation
SQL
10 votes195 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote205 views1 answer
Sql multiple into
SQL
0 vote184 views1 answer
Allow null in psql
SQL
3 votes173 views1 answer
Laravel paginate raw sql
SQL
1 vote151 views1 answer
Mysql login console
SQL
0 vote337 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote170 views1 answer
Power bi dax add related shows column but not working
SQL
1 vote175 views1 answer
Best sql course
SQL
2 votes167 views1 answer
Oracle generated column
SQL