On 10/29/2011 03:26 PM, Eric Ridge wrote:
Would y'all accept a patch that extended the "SELECT *" syntax to let
you list fields to exclude from the A_Star?
Quite regularly I'll be testing queries via psql and want to see all
the columns from a fairly wide table except maybe a giant text or xml
column. A syntax like:
SELECT * EXCLUDING (big_col1, big_col2) FROM foo;
If it is quite regular I would actually argue two things:
1. Use a view
2. You haven't normalized correctly
I am not trying to be a pedantic zealot or anything but those would be
my arguments against.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
