Re: [SQL] Problem with plpgsql function

2004-01-15 Thread Chris Bowlby
Ack, I knew it was something small, I was under the impression that I had been using that, it just took someone to point it out to make me look again :>... thanks.. On Thu, 2004-01-15 at 14:47, Joe Conway wrote: > Chris Bowlby wrote: > > select get_account_info('test.com'); > > > > I get this er

Re: [SQL] Problem with plpgsql function

2004-01-15 Thread Joe Conway
Chris Bowlby wrote: select get_account_info('test.com'); I get this error: ERROR: set-valued function called in context that cannot accept a set This is the "classic" SRF error -- you need to use an SRF like a relation in the FROM clause, so do this instead: select * FROM get_account_info('