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
otherfields 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