Question about functions..

From: Loren Koss <loren(at)pciway(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about functions..
Date: 2000-11-14 00:17:20
Message-ID: Pine.BSF.4.21.0011131617000.1013-100000@unix.pciway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How would you do the simple task of returning multiple rows of multiple
columns in a function?

ie:

create function test()
return int, int
as
'select col1, col2 from a'
language 'sql';

assuming col1 and col2 are integers.. I would like to port my db app from
MS SQL to postgres and would really need this type of functionality..

Thanks
Loren

Browse pgsql-general by date

  From Date Subject
Next Message Loren Koss 2000-11-14 00:18:42 Question regarding temporary tables & functions..
Previous Message Lamar Owen 2000-11-13 21:43:01 Re: 7.0.3 RPMs?