Question about functions.. - Mailing list pgsql-general

From Loren Koss
Subject Question about functions..
Date
Msg-id Pine.BSF.4.21.0011131617000.1013-100000@unix.pciway.com
Whole thread Raw
List 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




pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: 7.0.3 RPMs?
Next
From: Loren Koss
Date:
Subject: Question regarding temporary tables & functions..