/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 vote182 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote185 views1 answer
Postgresql print sessions using the database
SQL
0 vote171 views1 answer
Postgresql get current user name
SQL
1 vote189 views1 answer
Sqlserver create table from select
SQL
5 votes174 views1 answer
Sqlite alter table add column
SQL
0 vote199 views1 answer
Systems sql
SQL
0 vote271 views1 answer
Get last inserted primary key
SQL
10 votes168 views2 answers
Linux command line import mysql database
SQL
4 votes221 views1 answer
Postgresql create table with index
SQL
0 vote202 views1 answer
Insert value in identity
SQL