Re: Did this work in earlier version of Postgres?

On Thu, Mar 23, 2006 at 06:35:58PM -0500, Rod Taylor wrote:
> On Thu, 2006-03-23 at 17:31 -0600, Tony Caduto wrote:
> > I could have swore that this worked in earlier releases of Postgresql 
> > i.e. 7.4.
> > 
> > CREATE TABLE public.test
> > (
> > junk double NOT NULL,
> > CONSTRAINT junk_pkey PRIMARY KEY (junk)
> > )WITHOUT OIDS;
> > 
> > Now it gives a error that type double does not exist.
> 
> CREATE DOMAIN double AS float8;
> 
> There, now the type exists ;)

Except that there's issues with using domains for things as opposed to
base types (there's not full functionality).
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461