From: | "Guido Barosio" <gbarosio(at)gmail(dot)com> |
---|---|
To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org, "Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com> |
Subject: | Re: Did this work in earlier version of Postgres? |
Date: | 2006-03-23 23:49:17 |
Message-ID: | f7f6b4c70603231549iab0452flc73a602fc13ae52e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 Barosio
On 3/23/06, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> 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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Guido Barosio
-----------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-03-24 00:05:17 | Re: Did this work in earlier version of Postgres? |
Previous Message | Tony Caduto | 2006-03-23 23:43:49 | Re: Did this work in earlier version of Postgres? |