Skip site navigation (1) Skip section navigation (2)

Did this work in earlier version of Postgres?

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Did this work in earlier version of Postgres?
Date: 2006-03-23 23:31:21
Message-ID: 44232FC9.9000309@amsoftwaredesign.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

During the summer of 2004 I ported a large Firebird database to 7.x and 
firebird uses the term double which in PG is a float8 I believe.
Anyway i was able to just paste the Firebird ddl in to the query editor 
and the server would substitute the correct PG native type.

varchar works, how come double does not?

Thanks,

Tony

Responses

pgsql-hackers by date

Next:From: Rod TaylorDate: 2006-03-23 23:35:58
Subject: Re: Did this work in earlier version of Postgres?
Previous:From: Tom LaneDate: 2006-03-23 23:15:05
Subject: Re: [SUGGESTION] CVSync

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group