Rod Taylor wrote:
>
> For some reason a view with a select distinct, an order and an exception
> by will cause pg_dump to output a double order by -- one for each select
> which of course is bad SQL.
I think views should not have ORDER BY clauses at all in the first
place.
Jan
--
#
Rod Taylor <[EMAIL PROTECTED]> writes:
> For some reason a view with a select distinct, an order and an exception
> by will cause pg_dump to output a double order by -- one for each select
> which of course is bad SQL.
This is fixed in current sources and REL7_2 branch.
r
For some reason a view with a select distinct, an order and an exception
by will cause pg_dump to output a double order by -- one for each select
which of course is bad SQL.
PSQL
rbt_t=# create view test as select distinct relname, reltuples, relnatts
from pg_class where relkind = 't' excep
