/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 vote181 views1 answer
Not between mysql
SQL
5 votes183 views1 answer
Oracle get foreign keys on table
SQL
0 vote210 views1 answer
Error code 1451 sql
SQL
1 vote200 views1 answer
Postgres count string length
SQL
0 vote203 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
3 votes183 views3 answers
Mysql select table names
SQL
0 vote171 views1 answer
Mysql show category once count how many products
SQL
0 vote198 views1 answer
Oracle list datafiles
SQL
7 votes187 views3 answers
Select latest entry in sql table
SQL
0 vote213 views1 answer
Postgres full text search example
SQL