Re: Validity check in to_date?

From: "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru>
To: Iain <iain(at)mst(dot)co(dot)jp>
Cc: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Validity check in to_date?
Date: 2003-12-02 10:58:35
Message-ID: 20031202105835.GJ87728@dyatel.antar.bryansk.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alexander M. Pravking 2003-12-02 11:53:48 Re: Problem with intervals
Previous Message Alexander M. Pravking 2003-12-02 10:55:06 Re: Validity check in to_date?