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 ;) -- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org