Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: [GENERAL] PL/pgSQL and SETOF

From: Alvaro Herrera <alvherre(at)alvh.no-ip.org>
Date: Fri Nov 30 2007 - 16:21:32 EST


Pavel Stehule escribió:
> On 30/11/2007, Cultural Sublimation <cultural_sublimation@yahoo.com> wrote:

> > But still on that subject: is my version of get_items2 the simplest
> > that is possible in PL/pgSQL? It seems awfully verbose compared to
> > the SQL version...
>
> no. Your simplest version is historic relict and is available only in
> sql language. I am not sure, maybe in C language too.

But isn't the case that on 8.3 you would be able to rewrite it more easily using RETURN QUERY?

-- 
Alvaro Herrera                          Developer, 
http://www.PostgreSQL.org/
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Received on Fri Nov 30 16:22:50 2007

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 21:02:36 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library