On Thu, Mar 23, 2006 at 06:35:58PM -0500, Rod Taylor wrote: > 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 ;)
Except that there's issues with using domains for things as opposed to base types (there's not full functionality). -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq