Re: [BUGS] Can't join on null values

2004-07-16 Thread davidn-postgres
People, Thanks for your help with my problem with NULL values. Also, particular thanks for a hint on where to find a copy of SQL-92 standard, something I didn't already have. It was annoying to discover that UNIQUE didn't have what I felt was the "obvious" meaning, but it doesn't and PostgreSQL

[BUGS] Slow views

2004-07-16 Thread davidn-postgres
I know this has been discussed many times before but I'm not entirely satisfied with the answer, which I understand is "views are essentially macros". Despite that Postgres is producing the correct output, I hope you'll all agree that the performance issue is serious enough to call this a "bug."

Re: [BUGS] Improper processing of random values in sub-queries

2004-07-16 Thread davidn-postgres
Tom Lane <[EMAIL PROTECTED]> wrote: > I assume though that this is a made-up example and is not the case > that's really troubling you. What is the actual problem you are looking > at? I was generating random test data and naively assumed that ()::integer truncated its value, therefore I was gett