Re: [solved] aliases and set of record - Mailing list pgsql-general

On Thu, 20 Mar 2008 13:41:39 +0100
Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:

[snip]

>  for _row in
>   select _ItemID as __ItemID, _qty as __qty from
>     BasketItems(_BasketID,null)
>   loop
...

->

for _row in
 select bi._ItemID as __ItemID, bi._qty as __qty from
   BasketItems(_BasketID,null) as bi
loop

A bit annoying but works.

I hope it will be taken as a reference and not as garbage on the list.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it