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

2006-03-23 Thread Davidson, Robert
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 from source, but after looking at the mingw page was too

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

2006-03-22 Thread Tom Lane
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* > parame

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

2006-03-22 Thread Tom Lane
"Davidson, Robert" <[EMAIL PROTECTED]> writes: > ERROR: column "em.email_creation_datetime" must appear in the GROUP BY = > clause or be used in an aggregate function > CONTEXT: SQL statement " select to_char(to_timestamp(EXTRACT(HOUR FROM = > em.email_creation_datetime) || ':' || (EXTRACT(MINUTE