Re: plpgsql, return can contains any expression

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-patches(at)postgresql(dot)org, neilc(at)samurai(dot)com
Subject: Re: plpgsql, return can contains any expression
Date: 2006-09-15 07:31:17
Message-ID: BAY114-F15F05EBE3B03FFDD5A8A37F92E0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

>
>"Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> writes:
> > This patch allows using any row expression in return statement and does
> > transformation from untyped row to composite types if it's necessary.
>
>This patch doesn't seem to cope with cases where the supplied tuple has
>the wrong number of columns, and it doesn't look like it's being careful
>about dropped columns either. Also, that's a mighty bizarre-looking
>choice of cache memory context in coerce_to_tuple ... but then again,
>why are you bothering with a cache at all for temporary arrays?

I am sorry, Tom. But I don't understand. I can check number of columns,
ofcourse and I'll do it. What cache for temporary arrays do you mean?

Best regards
Pavel Stehule

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Joseph Krogh 2006-09-15 07:52:53 lower() not working correctly...?
Previous Message Neil Conway 2006-09-15 07:30:19 Re: Release notes

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-09-15 14:56:58 Re: [HACKERS] plpgsql, return can contains any expression
Previous Message Tom Lane 2006-09-15 05:27:04 Re: contrib uninstall scripts need some love