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: Rod Taylor <pg(at)rbt(dot)ca>
  • To: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
  • Cc: pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: Did this work in earlier version of Postgres?
  • Date: Thu, 23 Mar 2006 18:35:58 -0500
  • Message-id: <1143156958(dot)79972(dot)135(dot)camel(at)home>

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 ;)

-- 




Home | Main Index | Thread Index

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