/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

-1 vote195 views1 answer
Pl/sql how to delete a trigger
SQL
5 votes228 views2 answers
Create table mysql example auto_increment
SQL
0 vote206 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote200 views1 answer
Incorrect string value: mysql
SQL
0 vote251 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote191 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote245 views1 answer
Mysql wsrep ls
SQL
-1 vote196 views2 answers
Mysql get day of week
SQL
0 vote179 views1 answer
VSCode SQL Server Connection error
SQL
0 vote343 views1 answer
Hue hive UploadingTextFiletoHive
SQL