/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 vote340 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote315 views1 answer
Mysql is odd
SQL
0 vote326 views1 answer
Ms sql print more than 1 variable
SQL
0 vote336 views1 answer
Vbscript connect mssql
SQL
0 vote298 views1 answer
Mysql update sum same table
SQL
0 vote314 views1 answer
Show table structure mysql console
SQL
0 vote310 views1 answer
Learn sqlite dart
SQL
0 vote329 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote296 views1 answer
Time in sql server
SQL
0 vote382 views1 answer
How to get number of months between 2 dates sql server
SQL