X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 772C1D1D86A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  2 Dec 2003 10:59:07 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 94306-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  2 Dec 2003 06:58:38 -0400 (AST)
Received: from dyatel.antar.bryansk.ru (unknown [195.239.214.85])
	by svr1.postgresql.org (Postfix) with ESMTP id 94327D1B49E
	for <pgsql-sql@postgresql.org>; Tue,  2 Dec 2003 06:58:35 -0400 (AST)
Received: from fduch by dyatel.antar.bryansk.ru with local (Exim 4.24;
 FreeBSD)
	id 1AR8El-00088t-HN; Tue, 02 Dec 2003 13:58:35 +0300
Date: Tue, 2 Dec 2003 13:58:35 +0300
From: "Alexander M. Pravking" <fduch@antar.bryansk.ru>
To: Iain <iain@mst.co.jp>
Cc: Karel Zak <zakkr@zf.jcu.cz>, Christoph Haller <ch@rodos.fzk.de>,
	pgsql-sql@postgresql.org
Subject: Re: Validity check in to_date?
Message-ID: <20031202105835.GJ87728@dyatel.antar.bryansk.ru>
References: <20031127141125.GC87728@dyatel.antar.bryansk.ru>
	<200312020927.KAA17321@rodos> <20031202095713.GB17884@zf.jcu.cz>
	<005201c3b8c1$52374a60$7201a8c0@mst1x5r347kymb>
	<20031202105506.GI87728@dyatel.antar.bryansk.ru>
Mime-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
In-Reply-To: <20031202105506.GI87728@dyatel.antar.bryansk.ru>
User-Agent: Mutt/1.4.1i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200312/17
X-Sequence-Number: 16183

On Tue, Dec 02, 2003 at 01:55:06PM +0300, Alexander M. Pravking wrote:
> Try using check (VALUE::text::date).

Assuming check expects boolean result, it's (VALUE::text::date IS NOT NULL)


-- 
Fduch M. Pravking