On 2004.03.29 09:40 Bruno Wolff III wrote:
> On Mon, Mar 29, 2004 at 14:30:14 +0200,
> Bruno BAGUETTE <pgsql-ml(at)baguette(dot)net> wrote:
> > Hello,
> >
> > It may be a stupid question, but I'm looking to set a check clause
> in order
> > to be sure that a INTERVAL field is 00:00:00 or higher, but NOT
> negatives
> > values.
> >
> > How can I set that ?
>
> check (col_name >= '0 day'::interval)
Is there any way to write a constant interval without a cast?
It sure seems awkward to always have to cast. (AT least I always
seem to have to cast after my little bit of experiementing.)
(BTW, check (col_name >= CAST ('0 days' AS interval))
is more portable.)
Karl <kop(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein