/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 vote130 views1 answer
Mysql identified by syntax error
SQL
2 votes144 views1 answer
Mysql select default if null
SQL
0 vote139 views1 answer
Sql remove last 2 digit
SQL
0 vote125 views1 answer
10000000000000000000 am to meters
SQL
0 vote128 views1 answer
Get who is hired in specific month in sql
SQL
0 vote142 views1 answer
Sp in sql server
SQL
2 votes129 views2 answers
Mysql all columns
SQL
0 vote202 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote136 views1 answer
Oracle create table auto generated primary key
SQL
1 vote128 views1 answer
Mysql history command
SQL