Postgres/PgAdmin4 How to create function with Return Type as (TABLE student_name string)

by David   Last Updated January 14, 2018 11:06 AM

I am creating function using pgAdmin4 and the CODE Basically something like

BEGIN
   RETURN QUERY
    SELECT * FROM teest."students";
END

I am just wondering, how do I set the TABLE ReturnType as TABLE(applicant_id integer, ship_id integer) something like that. There's no TABLE return type there.

Thanks

Tags : sql


Related Questions