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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers