Dump/restore of views containing select distinct fails

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Dump/restore of views containing select distinct fails
Date: 2001-04-13 11:32:16
Message-ID: Pine.LNX.4.30.0104131320270.945-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=> create view testview as select relname, 'Constant'::text from pg_class;

=> \d testview
View "testview"
Attribute | Type | Modifier
-----------+------+----------
relname | name |
?column? | text |
View definition: SELECT DISTINCT pg_class.relname, 'Constant'::text FROM
pg_class ORDER BY pg_class.relname, 'Constant'::text;

Note how the order by clause is not valid SQL. You get

ERROR: Non-integer constant in ORDER BY

I suppose the ORDER BY clause appears because of some weird query parse
tree hackery and is not easy to get rid of. Maybe using column numbers
instead of spelling out the select list again would work?

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-04-13 13:25:45 Re: Call for platforms
Previous Message Mark Butler 2001-04-13 09:21:24 Re: NUMERIC type efficiency problem