On Oct 30, 2011, at 11:54 AM, Robert Haas wrote: >> If you know that you want all fields except X, Y and Z, why should you be >> forced to manually cut and paste all the other fields into the view >> definition? That's wasted time and effort that could better be spent >> elsewhere. > > I agree. This isn't something I would recommend that people do in the > queries they embed in their application, but for ad-hoc queries it > comes up all the time.
It can also be very useful for generating queries that need to omit rows, such as in PL/pgSQL functions that use EXECUTE, not to mention client code. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
