/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 vote226 views1 answer
How to switch user in mysql
SQL
0 vote244 views1 answer
Add mysql database to power bi web
SQL
33 votes224 views2 answers
Postgres how to add field created at
SQL
1 vote224 views1 answer
Does insert into overwrite sql
SQL
-1 vote255 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote224 views1 answer
Replace content value from old to new sql
SQL
0 vote222 views1 answer
Sql database connectivity
SQL
0 vote219 views1 answer
No suitable driver found for sqlite
SQL
0 vote232 views2 answers
Many to many flask-sqlalchemy
SQL
2 votes235 views1 answer
Scaffold npgsql net core
SQL