/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 vote246 views1 answer
Oracle date winter time
SQL
0 vote240 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote228 views1 answer
Get url of cpanel database hostname
SQL
0 vote256 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
24 votes224 views5 answers
Sql reset auto increment
SQL
3 votes247 views1 answer
Select database in sql
SQL
0 vote233 views3 answers
Postgresql allow remote connections
SQL
0 vote240 views1 answer
Mysql grant grant option
SQL
8 votes238 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote251 views2 answers
Collation in sql
SQL