/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 vote236 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote209 views1 answer
Oracle job session
SQL
0 vote247 views1 answer
Python mysql check if database exists
SQL
2 votes212 views1 answer
Oracle sql concatenate results into string
SQL
0 vote219 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote212 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote213 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote210 views1 answer
Psql check if value in array
SQL
6 votes261 views2 answers
Mysql convert timestamp to date
SQL
0 vote216 views1 answer
Oracle query archivemode
SQL