Re: Confusing terminology - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Confusing terminology
Date
Msg-id Pine.LNX.4.30.0201201723290.712-100000@peter.localdomain
Whole thread Raw
In response to Re: Confusing terminology  ("Roderick A. Anderson" <raanders@tincan.org>)
List pgsql-hackers
Roderick A. Anderson writes:

> It was a rhetorical question (aka. smart-ass).  My point was a table,
> view, sequence, and their friends are all relations.  Or at least to my
> understanding the table and view are relations.
>    And therefore Relation 'foo' already exists makes sense to me.

From a point of view of implementation, the term "relation" also covers
indexes, which can be confusing.  Standard SQL (which doesn't have indexes
or sequences) uses the term "table" to mean both regular tables and views.
Neither of these choices are entirely pretty.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: [GENERAL] PostgreSQL Licence: GNU/GPL
Next
From: Tom Lane
Date:
Subject: Re: pltlc and pltlcu problems