"Peter Wright" <[EMAIL PROTECTED]> writes:
> Description:Rows returned that should be excluded by WHERE clause
Interesting point. The view and union don't seem to be the issue;
I think the problem can be expressed as
regression=# select 2 as id, max(b) from t2 having 2 = 1;
id | max
--
The following bug has been logged online:
Bug reference: 1531
Logged by: Markus Bertheau
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Linux FC3
Description:rotated log truncation broken
Details:
The log truncation is broken for me. It
Markus Bertheau wrote:
The following bug has been logged online:
Bug reference: 1531
Logged by: Markus Bertheau
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Linux FC3
Description:rotated log truncation broken
Details:
The log truncation
On Monday 07 March 2005 16:22, Robert Treat wrote:
> On Sunday 06 March 2005 15:25, Hashem Masoud wrote:
> Thanks for the report! Attached patch fixes this and 3-4 other typos as
> well.
Hashem has kindly pointed out a few more typos in the FAQ that I have added
in, please apply this patch inste
"Markus Bertheau" <[EMAIL PROTECTED]> writes:
> The log truncation is broken for me. It works as advertised, and I follow
> the argumentation behind it, but for my scenario it is not working:
> I use the computer only in work hours; it's shut down in the night.
> I use the standard log rotation t
Just an interesting side note here, this behavior is identical to DB2. I am not
sure if that makes it correct or not, but here is an example.
[EMAIL PROTECTED] gill]$ db2 "select 2 as id, max(apn3) from phoenix.client
where 2 =1"
ID 2
--- --
2 -
1 record(s
"Gill, Jerry T." <[EMAIL PROTECTED]> writes:
> Just an interesting side note here, this behavior is identical to DB2. I am
> not sure if that makes it correct or not, but here is an example.
> [EMAIL PROTECTED] gill]$ db2 "select 2 as id, max(apn3) from phoenix.client
> where 2 =1"
> ID
Sorry Tom, I missed a sentence in you previous email. My understanding of the
having clause is that the row should be filtered. Here is the same example with
the having clause in DB2.
[EMAIL PROTECTED] gill]$ db2 "select 2 as id, max(apn3) from phoenix.client
having 2 =1"
ID 2
--
