Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: extract day from interval
- From: Seb <spluque(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: extract day from interval
- Date: Thu, 27 Mar 2008 23:36:20 -0500
On Fri, 28 Mar 2008 00:06:59 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: [...] > Efficiency is moot, it's just plain wrong. Or at least something is > wrong here, Subtraction of two "date" values gives an integer number > of days already, so I'd expect the EXTRACT to fail altogether. You > sure the date columns are type date and not type timestamp? My mistake, yes, sure they're both timestamp! -- Seb
- References:
- extract day from interval
- From: Seb
- Re: extract day from interval
- From: Tom Lane
- extract day from interval
- Prev by Date: Re: extract day from interval
- Next by Date: Re: Re: Survey: renaming/removing script binaries (createdb, createuser...)
- Previous by thread: Re: extract day from interval
- Next by thread: Reminder: Google Summer of Code deadline 72 hours away!
- Indexes: