/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

9 votes171 views3 answers
Import DB through mysql console
SQL
0 vote154 views1 answer
Sqlite3_open_v2
SQL
2 votes144 views2 answers
Exec procedure pl sql
SQL
0 vote136 views1 answer
Create api project in visual studio 2019 and sql server
SQL
2 votes110 views1 answer
Foreign key example in dbms
SQL
0 vote138 views1 answer
Error code 1241 mysql
SQL
0 vote147 views1 answer
Find number of entries sql
SQL
4 votes153 views1 answer
Find tables with column name in sql
SQL
3 votes154 views4 answers
Psql list tables in schema
SQL
0 vote144 views1 answer
Postrgres trunc
SQL