Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Davidson, Robert" <robdavid(at)amazon(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: [SQL] Function Parameters in GROUP BY clause cause errors
Date: 2006-03-23 04:27:11
Message-ID: 2742.1143088031@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-sql
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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-03-23 04:50:00
Subject: Re: inpricise checkpoint stats
Previous:From: Christian Paul B. CosinasDate: 2006-03-23 01:33:33
Subject: Re: Function Parameters in GROUP BY clause cause errors

pgsql-sql by date

Next:From: Davidson, RobertDate: 2006-03-23 13:30:28
Subject: Re: [SQL] Function Parameters in GROUP BY clause cause errors
Previous:From: Tom LaneDate: 2006-03-23 02:47:31
Subject: Re: OUT parameter

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group