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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group