Skip site navigation (1) Skip section navigation (2)

Re: index over timestamp not being used

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: index over timestamp not being used
Date: 2007-07-25 13:05:10
Message-ID: 200707251505.11182.mweilguni@sime.com (view raw or flat)
Thread:
Lists: pgsql-performance
Am Dienstag 24 Juli 2007 schrieb Tom Lane:
> > I thought the
> > to_char/to_date/to_timestamp functions were intented for this purposes
>
> No, they're intended for dealing with wacky formats that the regular
> input/output routines can't understand or produce.

Really? I use them alot, because of possible problems with different date 
formats. 20070503 means May 3, 2007 for germans, I don't know what it means 
to US citizens, but following the strange logic of having the month first 
(8/13/2005) it might mean March 5, 2007 too. Therefore, using to_timestamp 
seems to be a safe choice for me, working in any environment regardless of 
the "date_style" setting.


In response to

Responses

pgsql-performance by date

Next:From: Mario WeilguniDate: 2007-07-25 13:07:23
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
Previous:From: Simon RiggsDate: 2007-07-25 12:52:13
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group