On 23/3/06 23:43, Tony Caduto [EMAIL PROTECTED] wrote:
Peter Eisentraut wrote:
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.
Ok, Thanks for clearing that up for me :-)
Maybe
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
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.
From the docs:
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
Tony Caduto [EMAIL PROTECTED] writes:
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.
[ tries
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
Peter Eisentraut wrote:
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.
Ok, Thanks for clearing that up for me :-)
Maybe it was pgAdmin that did the substitution.
Thanks,
Tony
Which is actually a float8 :)
CREATE TABLE public.test
(
junk double precision,
);
alter table public.test add column foo float8;
Table public.test
Column | Type |
+--+--
junk | double precision |
punk | double precision |
Regards,
Guido
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
On Thu, 2006-03-23 at 16:05 -0800, Joshua D. Drake wrote:
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
Now it gives a error that type double does not exist.
CREATE DOMAIN double AS float8;
There, now the type exists ;)
That's a little too perl for me ;)
I suppose it depends on the goal. If it is an application that is to be
supported on more than one database, defining types and other
On Thu, 2006-03-23 at 16:41 -0800, Joshua D. Drake wrote:
Now it gives a error that type double does not exist.
CREATE DOMAIN double AS float8;
There, now the type exists ;)
That's a little too perl for me ;)
I suppose it depends on the goal. If it is an application that is to be
12 matches
Mail list logo