"Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com> writes:
> It turns out that even when I removed the CASE statement from the VIEW, the
> performance problem remained. I had to remove the conditional as well from
> the VIEW.
> cancel_date < expire_date AS canceled,
> Do you know why? I'm running 7.3.4, by the way.
7.3 is even stupider than 7.4, is why ...
In 7.3 only a view whose targetlist consists of simple column references
can be pulled up into the nullable side of an outer join.
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: birdy edwards||Date: 2004-09-21 05:55:56|
|Subject: [ocpfree] Info Needed about OCA|
|Previous:||From: Joe Conway||Date: 2004-09-21 04:44:02|
|Subject: Re: PL/pgSQL multidimension (matrix) array in function|