Re: Interval constant syntax, was Re: Interval & check clause

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Cc: Bruno BAGUETTE <pgsql-ml(at)baguette(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Interval constant syntax, was Re: Interval & check clause
Date: 2004-03-30 05:22:36
Message-ID: 20040330052236.GA14444@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 29, 2004 at 15:28:59 -0600,
"Karl O. Pinc" <kop(at)meme(dot)com> wrote:
>
> And this was my scratch psql test:
>
> => select CAST('1/1/2004' AS date) - '3 years';
> ERROR: Bad date external representation '3 years'
>
> I am using 7.3 so maybe this has been fixed. Or it's just the
> operator, some require casts and some don't and you just have to find
> out the hard way. :(

This is different in that you are using - instead of >= . Date - Date
will get picked because that is the only - operator with a left operand
of type date. You are trying to use timestamp - interval (with date
getting promoted to timestamp).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-30 05:42:28 Re: Interval constant syntax, was Re: Interval & check clause
Previous Message Andrew Rawnsley 2004-03-30 04:08:25 Re: PG vs MySQL