From: | Eric Ridge <eebbrr(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Thoughts on "SELECT * EXCLUDING (...) FROM ..."? |
Date: | 2011-10-29 22:26:19 |
Message-ID: | CANcm6wbR3EG7t-G=Txy64Yt8nR6YbpzFRuTewJQ+kCq=rZ8M2A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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;
would be pretty handy. It would definitely save some typing in
certain cases. It seems like such a syntax would better document the
intent of a query too, rather than leaving one wondering if "big_col1"
was supposed to be omitted from the target list or not.
Anyways, I just wanted to run the idea by youse guys before I put too
much more effort into it. I've already made what appear to be the
minimum necessary changes to gram.y, and a few quick greps through the
code make me think the rest will be pretty easy.
Maybe the SQL spec says something about this and nobody's done the work yet?
Thanks for your input!
eric
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2011-10-29 22:35:47 | Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."? |
Previous Message | Jeff Davis | 2011-10-29 22:00:52 | Re: strange code in array_in |