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
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."
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