| Lists: | pgsql-sql |
|---|
| From: | "Nacef LABIDI" <nacef(dot)l(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Select function with set return type |
| Date: | 2008-08-18 11:03:07 |
| Message-ID: | f16f7ea00808180403v7a3bada7gc03e4bfc4f7ede0@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
Hi all,
I am writing some functions with retrun type as a SETOF of a datatype that I
have defined. How can I test them with a select statement.
Doing select my_function(); return set valued function called in context
that cannot accept a set
Thanks to all
Nacef
| From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Select function with set return type |
| Date: | 2008-08-18 11:12:14 |
| Message-ID: | 20080818111214.GA7234@tux |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
Nacef LABIDI <nacef(dot)l(at)gmail(dot)com> schrieb:
> Hi all,
>
> I am writing some functions with retrun type as a SETOF of a datatype that I
> have defined. How can I test them with a select statement.
> Doing select my_function(); return set valued function called in context that
> cannot accept a set
Try 'select * from my_function();'
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°