Re: [SQL] Function Parameters in GROUP BY clause cause errors

How amazing is that? I call it a night and come back to find that a bug has been identified and patched while I sleep.

When will it appear in the binaries (I see that the release version is still 8.1.3)? I thought about trying to compile
fromsource, but after looking at the mingw page was too intimidated by figuring out what to download to try compiling
source.

Best Regards,

Robert Davidson

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, March 22, 2006 8:27 PM
To: Davidson, Robert
Cc: pgsql-sql@postgresql.org; pgsql-bugs@postgresql.org
Subject: Re: [SQL] Function Parameters in GROUP BY clause cause errors

I wrote:
> Hmm, this seems like a plpgsql deficiency.  It feels it can generate a
> separate parameter symbol ($n) for each occurrence of each variable it
> passes into a SQL query.  But for this query to be legal, the two
> instances of IntervalMinutes have to be represented by the *same*
> parameter symbol (notice they are not in the regurgitated query).

> It would be more efficient anyway to not generate multiple parameters
> for the same value, so we oughta fix this.

Patch applied to HEAD and 8.1 branches.
        regards, tom lane