On Nov 30, 2007 1:18 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
> On 30/11/2007, Cultural Sublimation <cultural_sublimation@xxxxxxxxx> 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.
It is extremely useful to be able call functions in this way. I
really wish it were possible to do this with pl/sql functions as
well...
merlin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
