Artis Caune escribió: > Hi, > > What is the correct way of writing plpgsql function which needs return > columns from multiple tables? > > e.x.: > SELECT email FROM emails WHERE id = 1 > SELECT backend FROM backends WHERE id = 1 > > I need plpgsql function return both email and backend in one line, like: > SELECT email, backend FROM ...
Hmm, maybe select email, backend from emails, backends where email.id = 1 and backend.id = 1; ? You don't need a plpgsql function for this ... -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
