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/