Frank van Vugt ftm.van.v...@foxi.nl writes:
One might consider adding a single line to the end of 9.9 of the docs that
warns for this behaviour and/or add the specific example?
I put some more explanation and examples into the 9.0 docs:
Hi Tom,
The rationale is do what the SQL spec says ;-)
can't argue with the standard ;)
I seem to recall a previous discussion in the PG lists
Good memory !
Adding 'sql standard' to the search options helped, this issue seems to elude
people every now and then, given (amongst others):
Hi,
This doesn't seem to make sense to me, can someone explain the rationale
behind it?
postgres=# select version();
version
---
PostgreSQL 8.4.4 on
Frank van Vugt ftm.van.v...@foxi.nl writes:
This doesn't seem to make sense to me, can someone explain the rationale
behind it?
The rationale is do what the SQL spec says ;-)
What the spec says is
( S1 S2 AND NOT ( S1 = T2 AND T1 = T2 ) )
OR
( S2