Tag: plpgsql

Return multiple fields as a record in PostgreSQL with PL/pgSQL

plpgsql postgresql sql stored-procedures types

I am writing a SP, using PL/pgSQL. I want to return a record, comprised of fields from several different tables. Could look something like this: CREATE OR REPLACE FUNCTION get_object_fields(name text)…