Re: [GENERAL] returns setof rec... simple exampe doesn't work

2007-07-12 Thread Joshua D. Drake
:* Monday, July 09, 2007 4:07 PM *To:* pgsql-general@postgresql.org *Subject:* [GENERAL] returns setof rec... simple exampe doesn't work I’ve googled this one and tried everything (except the correct solution of course) until tears are starting to flow. Please help. Complete example below. 7

Re: [GENERAL] returns setof rec... simple exampe doesn't work

2007-07-12 Thread Gauthier, Dave
bject: [GENERAL] returns setof rec... simple exampe doesn't work I've googled this one and tried everything (except the correct solution of course) until tears are starting to flow. Please help. Complete example below. 7.4.13 on suse-64 x86 create table mytable (mystring varch

Re: [GENERAL] returns setof rec... simple exampe doesn't work

2007-07-12 Thread Stephen Frost
* Gauthier, Dave ([EMAIL PROTECTED]) wrote: > stdb=# select myfunc(); > ERROR: set-valued function called in context that cannot accept a set select * from myfunc(); ? Stephen signature.asc Description: Digital signature

[GENERAL] returns setof rec... simple exampe doesn't work

2007-07-12 Thread Gauthier, Dave
I've googled this one and tried everything (except the correct solution of course) until tears are starting to flow. Please help. Complete example below. 7.4.13 on suse-64 x86 create table mytable (mystring varchar, myreal real); insert into mytable (mystring,myreal) values ('abc',1.2