| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: "SELECT *" vs hidden columns and logical column order |
| Date: | 2017-06-30 18:09:53 |
| Message-ID: | 3e8dfc3f-c350-5ee7-9d0d-e345ce7f88ba@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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's that way in another
> product), so I guess that's basically the same as (1).
In my reading of the standard, those start/end time columns would show
up normally in SELECT *.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2017-06-30 18:15:01 | Re: pg_stop_backup(wait_for_archive := true) on standby server |
| Previous Message | Peter Eisentraut | 2017-06-30 18:04:56 | Re: CREATE COLLATION definitional questions for ICU |