/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

1 vote139 views1 answer
Alter database datafile maxsize 32g
SQL
21 votes136 views4 answers
Oracle add column
SQL
0 vote129 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote115 views1 answer
Partitioning in oracle-base
SQL
0 vote135 views1 answer
Mysql check if lowercase
SQL
9 votes125 views4 answers
How to alter table column name in mysql
SQL
0 vote129 views1 answer
Install squirrel sql ubuntu
SQL
4 votes130 views2 answers
Sql offset
SQL
0 vote141 views2 answers
Transaction php
SQL
2 votes133 views3 answers
Mysql pass command from command line
SQL