/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 vote280 views1 answer
If null don't update
SQL
2 votes293 views3 answers
Postgresql reset auto increment
SQL
0 vote294 views1 answer
Mysql search multiple tables
SQL
0 vote310 views1 answer
Groupby sort sql hive
SQL
0 vote316 views2 answers
Mysql update two tables at once
SQL
6 votes319 views4 answers
Mysql update set
SQL
0 vote310 views1 answer
ACCEPT nome PROMPT on oracle
SQL
14 votes290 views3 answers
SQL trim
SQL
2 votes311 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote286 views1 answer
Mysql update privileges
SQL