/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 vote168 views1 answer
Nth max in my sql
SQL
0 vote172 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote175 views1 answer
How to drop function in sql
SQL
2 votes206 views1 answer
Search query in mysql
SQL
0 vote213 views1 answer
Postgresql create table default value timestamp
SQL
0 vote204 views1 answer
How to find symmetric pairs in sql
SQL
4 votes173 views1 answer
Wildcard in sql
SQL
0 vote219 views1 answer
Oracle swap partition
SQL
1 vote160 views1 answer
Using SQL in rails migration
SQL
1 vote172 views1 answer
Mysql copy table1 to table2
SQL