On 30/11/2007, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote:> Pavel Stehule escribió:> > On 30/11/2007, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote:> > > Pavel Stehule escribió:> > > > 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.> > >> > > But isn't the case that on 8.3 you would be able to rewrite it more> > > easily using RETURN QUERY?> >> > yes. sure. But it is different question than call SRF function in> > normal context.>> Hmm, you are misunderstanding Cultural or I am. I think his verbosity> comment is not about the way the function is called, but rather about> the function body itself.> It's my English. I am sorry. You have true. Thank you for correction Pavel > --> Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4"> "Before you were born your parents weren't as boring as they are now. They> got that way paying your bills, cleaning up your room and listening to you> tell them how idealistic you are." -- Charles J. Sykes' advice to teenagers> ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend