/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 vote273 views1 answer
Postgres week number
SQL
0 vote270 views1 answer
Every Derived yable must have its own alias
SQL
0 vote291 views1 answer
Drop view in mysql
SQL
0 vote263 views2 answers
Sql join on wildcard
SQL
3 votes260 views1 answer
Oracle get trigger ddl
SQL
9 votes290 views3 answers
Find all tables with column name
SQL
13 votes276 views4 answers
Command line mysql import
SQL
0 vote266 views1 answer
Connect laravel to mysql on mac
SQL
0 vote246 views1 answer
Mysql update sum same table
SQL
2 votes274 views1 answer
Mysql now format
SQL