Re: Function Parameters in GROUP BY clause cause errors

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Function Parameters in GROUP BY clause cause errors
Дата
Msg-id 2742.1143088031@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Function Parameters in GROUP BY clause cause errors  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: OUT parameter
Следующее
От: "Davidson, Robert"
Дата:
Сообщение: Re: Function Parameters in GROUP BY clause cause errors