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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Did this work in earlier version of Postgres?

  • From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
  • To: Rod Taylor <pg(at)rbt(dot)ca>
  • Cc: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>, pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: Did this work in earlier version of Postgres?
  • Date: Thu, 23 Mar 2006 16:05:17 -0800
  • Message-id: <442337BD(dot)1040600(at)commandprompt(dot)com>
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 ;)


That's a little too perl for me ;)

Joshua D. Drake
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group