Re: Perhaps a possible new feature to a future PostgreSQL release

2023-11-20 Thread Laurenz Albe
On Mon, 2023-11-20 at 09:52 +, Erki Eessaar wrote: > Let me assume that there is a table T with columns a, b, c, d, e, f, g, and h. > > If one wants to select data from all the columns except d and e, then one has > to write > > SELECT a, b, c, f, g, h > FROM T; > > instead of writing  > >

Perhaps a possible new feature to a future PostgreSQL release

2023-11-20 Thread Erki Eessaar
Hello Let me assume that there is a table T with columns a, b, c, d, e, f, g, and h. If one wants to select data from all the columns except d and e, then one has to write SELECT a, b, c, f, g, h FROM T; instead of writing SELECT ALL BUT (d, e) FROM T; or something similar (perhaps by using