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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461