/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 vote346 views1 answer
Compression of dabatase mysqldumo
SQL
1 vote359 views1 answer
Python escape mysql
SQL
5 votes360 views4 answers
Change auto increment mysql
SQL
0 vote349 views1 answer
Sql remove last 2 digit
SQL
0 vote359 views1 answer
Group by join columns per table
SQL
3 votes377 views1 answer
Only join in sql
SQL
2 votes353 views1 answer
Oracle calculated column
SQL
0 vote297 views1 answer
Sql table to store status
SQL
1 vote338 views1 answer
User privileges postgresql information_schema
SQL
0 vote409 views1 answer
How to find date from date table in sql
SQL