Re: [HACKERS] "SELECT *" vs hidden columns and logical column order

2017-07-02 Thread Thomas Munro
On Sat, Jul 1, 2017 at 6:09 AM, Peter Eisentraut wrote: > On 6/28/17 23:52, Thomas Munro wrote: >> 2. SQL:2011 temporal tables track system time and/or valid time with >> columns that users create and then declare to be temporal control >> columns. I don't think they show up unless you name them

Re: [HACKERS] "SELECT *" vs hidden columns and logical column order

2017-06-30 Thread Peter Eisentraut
On 6/28/17 23:52, Thomas Munro wrote: > 2. SQL:2011 temporal tables track system time and/or valid time with > columns that users create and then declare to be temporal control > columns. I don't think they show up unless you name them directly (I > didn't check the standard but I noticed that it

Re: [HACKERS] "SELECT *" vs hidden columns and logical column order

2017-06-30 Thread Robert Haas
On Wed, Jun 28, 2017 at 11:52 PM, Thomas Munro wrote: > I am aware of at three potential projects that would change the > meaning of "SELECT *": > > 1. Incremental MATERIALIZED VIEW maintenance probably needs to be > able to use a hidden counter column which you can ask for by name but > will oth

[HACKERS] "SELECT *" vs hidden columns and logical column order

2017-06-28 Thread Thomas Munro
Hi hackers, I am aware of at three potential projects that would change the meaning of "SELECT *": 1. Incremental MATERIALIZED VIEW maintenance probably needs to be able to use a hidden counter column which you can ask for by name but will otherwise not show up to users: https://www.postgresql.