/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

4 votes115 views1 answer
Postgresql change default value
SQL
1 vote118 views1 answer
Oracle create_program
SQL
9 votes109 views2 answers
Oracle all tables in schema
SQL
0 vote116 views1 answer
Mysql trim characters
SQL
0 vote116 views1 answer
T-sql update table variale
SQL
23 votes130 views5 answers
Sql substring
SQL
1 vote132 views1 answer
Sql select row with max date
SQL
8 votes80 views2 answers
Alter column name in mssql
SQL
0 vote116 views1 answer
Oracle allow space to user
SQL
-1 vote143 views2 answers
Mysql get day of week
SQL