/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 vote190 views1 answer
Longtext sql
SQL
6 votes257 views2 answers
Install psql mac
SQL
1 vote209 views1 answer
Drop primary key oracle
SQL
7 votes244 views1 answer
Sql disable safe mode
SQL
0 vote214 views1 answer
Data directory postgresql
SQL
11 votes183 views4 answers
MYSQL LOGIN
SQL
3 votes223 views3 answers
Sql current year
SQL
0 vote232 views1 answer
Sql date with year
SQL
1 vote206 views1 answer
Show structure of table in sql
SQL
10 votes198 views2 answers
Sql rtrim
SQL