/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 vote197 views1 answer
Can sqldatareader be null
SQL
2 votes226 views1 answer
Oracle Column Names of a table
SQL
0 vote197 views1 answer
Postgresql function ROUND
SQL
0 vote188 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote196 views1 answer
Laravel eloquent get generated sql
SQL
4 votes191 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote141 views1 answer
Update sql join multiple tables
SQL
0 vote202 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
12 votes194 views4 answers
Import mysql database command line linux
SQL
0 vote196 views1 answer
Mysql shell ERROR: Not connected.
SQL