[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-hackers
Subject: Re: [HACKERS] "SELECT *" vs hidden columns and logical column order
From: Peter Eisentraut <peter.eisentraut () 2ndquadrant ! com>
Date: 2017-06-30 18:09:53
Message-ID: 3e8dfc3f-c350-5ee7-9d0d-e345ce7f88ba () 2ndquadrant ! com
[Download RAW message or body]
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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic