| From: | Guyren Howe <guyren(at)gmail(dot)com> |
|---|---|
| To: | Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com> |
| Cc: | Miles Elam <miles(dot)elam(at)productops(dot)com>, Josef Šimánek <josef(dot)simanek(at)gmail(dot)com>, Stanislav Motyčka <stanislav(dot)motycka(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |
| Date: | 2020-02-25 19:39:09 |
| Message-ID: | 04749208-2BB9-4E4B-ADFF-464713C6D5CC@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Feb 25, 2020, at 11:28 , Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com> wrote:
>
> On Tue, Feb 25, 2020 at 2:18 AM Stanislav Motyčka
> <stanislav(dot)motycka(at)gmail(dot)com <mailto:stanislav(dot)motycka(at)gmail(dot)com>> wrote:
>> Sometimes (for tables with many columns) it would be better and easier to write "SELECT" statement with clause "EXCEPT":
>> "SELECT * [EXCEPT col1 [,col2]] FROM …"
The single biggest benefit is that I could write many more views that don’t need to be changed when I change the underlying table.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stanislav Motycka | 2020-02-25 19:46:37 | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |
| Previous Message | Justin | 2020-02-25 19:35:05 | Re: Connections dropping while using Postgres backend DB with Ejabberd |