Re: Did this work in earlier version of Postgres?

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 ;)

--