Interval constant syntax, was Re: Interval & check clause - Mailing list pgsql-general

On 2004.03.29 09:40 Bruno Wolff III wrote:
> On Mon, Mar 29, 2004 at 14:30:14 +0200,
>   Bruno BAGUETTE <pgsql-ml@baguette.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@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein