/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

4 votes336 views1 answer
What are the data types in sql
SQL
0 vote430 views1 answer
How to check common records in 2 table
SQL
0 vote382 views1 answer
Trigger vérifier stock
SQL
0 vote343 views1 answer
Sql cheetsheet
SQL
2 votes343 views1 answer
Columns Present in a table
SQL
0 vote357 views1 answer
Mysql server not starting in xampp in mac
SQL
4 votes355 views2 answers
Select first and last row mysql
SQL
0 vote361 views1 answer
Sql ignore
SQL
1 vote345 views2 answers
Login to mysql
SQL
0 vote354 views1 answer
Str_to_date sql server
SQL