Re: Typed tables

On mån, 2010-01-11 at 19:27 -0500, Andrew Chernow wrote:
> Peter Eisentraut wrote:
> > On mån, 2010-01-11 at 15:02 -0500, Andrew Chernow wrote:
> >> ISTM that the ultimate would be a 'create table (...._) without storage' 
> >> (or some'm) and make 'create type' an alternate syntax for SQL 
> >> conformance.
> > 
> > I don't really understand the purpose of that.
> > 
> 
> What is the point of CREATE TYPE name AS () syntax?  Why would one use create 
> type when there is create table?  Does it provide additional functionality I am 
> unaware of or does it exist for comformance reasons?

Well, that is a very deep question. ;-)  I suppose a concise answer
would be that types are for passing data around between functions, and
tables are for storing data on disk.