Re: [BUGS] BUG #2503: Query results differ based on record count

2006-06-30 Thread Russell Francis
Alvaro Herrera wrote: > Russell Francis wrote: > >> If a SELECT statement contains a table in it's FROM clause which has 0 >> records in it, the query will not return any results. If a record is added >> to the table even though it shouldn't modify the results

[BUGS] BUG #2503: Query results differ based on record count of unrelated table.

2006-06-29 Thread Russell Francis
The following bug has been logged online: Bug reference: 2503 Logged by: Russell Francis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: FreeBSD 6.1 Description:Query results differ based on record count of unrelated table. Details