On Fri, Aug 12, 2011 at 4:11 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> On tor, 2011-08-04 at 14:59 -0400, Robert Haas wrote:
>> > Well, the facts are: According to the SQL standard, "table"
>> includes
>> > views and foreign tables. According to scientific-ish database
>> > literature, a table is a relation and vice versa.
>>
>> So what are you supposed to call it if you mean, specifically, a
>> table?
>
> "A table is either a base table, a derived table, a transient table, or
> a viewed table." (SQL/MED adds "foreign table".)
>
> Just FYI.
Base table seems clear enough, and a transient table sounds like a
temporary table, but what is a derived table? Is a viewed table a
view?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
