Re: order of adding date & interval values?

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Lev Lvovsky <lists1(at)sonous(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: order of adding date & interval values?
Date: 2002-05-03 02:41:23
Message-ID: 3CD1F8D3.88C24806@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

...
> '40 years'::interval
> CAST('40 years' as interval)
> The former is succinct, the latter SQL-standard ...

as is

interval '40 years'

(give or take some suffix tokens).

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lev Lvovsky 2002-05-03 03:10:37 Re: order of adding date & interval values?
Previous Message Tom Lane 2002-05-03 02:31:22 Re: order of adding date & interval values?