Alexandr Popov <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE VIEW v1 AS SELECT DISTINCT a,b, -1 AS d, -1 AS e FROM t1;
> After this i dump database with pg_dump and have following output. > CREATE VIEW v1 AS > SELECT DISTINCT t1.a, t1.b, -1 AS d, -1 AS e FROM t1 ORDER BY t1.a, t1.b, > -1::integer, -1::integer; Sigh ... this is a bug in my patch of a few months ago: http://archives.postgresql.org/pgsql-committers/2008-01/msg00081.php It needs to be parenthesizing those constants, because as-is the :: binds more tightly than the -, and "-(1::integer)" is a run-time negation, not a simple constant. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general