default modifiers for 7.2b4

From: "mike" <matrix(at)vianet(dot)ca>
To: "PostgreSQL Mailing Lists-General" <pgsql-general(at)postgresql(dot)org>
Subject: default modifiers for 7.2b4
Date: 2001-12-23 01:25:57
Message-ID: 01d101c18b50$c5e2e370$4100000a@generator
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

has the default clause been changed for 7.2b4 so as not use a statement as such:

create table news(
id serial,
date date DEFAULT 'select now()::date' NOT NULL,
topic varchar(256),
body text
);

the above query results in ERROR: Bad date external representation 'select now()::date', yet if I use this on a production 7.1.2 machine it works fine.

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-12-23 01:56:09 Re: default modifiers for 7.2b4
Previous Message Masaru Sugawara 2001-12-22 16:26:07 Re: getting most recent row efficiently

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-12-23 01:45:23 Re: Possible bug in vacuum redo
Previous Message Bruce Momjian 2001-12-23 00:19:53 Re: HISTORY file