Postgres Pro
Downloads
Home   >   mailing lists

Re: order of adding date & interval values? - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: order of adding date & interval values?
Date
Msg-id 3CD1F8D3.88C24806@fourpalms.org
Whole thread Raw
In response to order of adding date & interval values?  (Lev Lvovsky <lists1@sonous.com>)
List pgsql-general
Tree view 
...
>         '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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: order of adding date & interval values?
Next
From: Lev Lvovsky
Date:
Subject: Re: order of adding date & interval values?