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('

[SQL] Problem with plpgsql function

2004-01-15 Thread Chris Bowlby
Hi All, I've been bangin away on a 7.4.x based database server trying to get a plpgsql function to work the way I'm expecting it to. I've used various resourced on the net to come up with the function, and as far as I can tell it's "in proper form", but I've got the feeling that I'm missing some