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/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly