Re: Did this work in earlier version of Postgres?

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;

There has never been a type named double in PostgreSQL.  The type name 
mandated by the SQL standard is double precision, and PostgreSQL 
supports that.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/