Re: Strange results from to_timestamp - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Strange results from to_timestamp
Date
Msg-id 200604190311.k3J3BQj14538@candle.pha.pa.us
Whole thread Raw
In response to Re: Strange results from to_timestamp  ("Mario Weilguni" <mario.weilguni@icomedias.com>)
List pgsql-hackers
Mario Weilguni wrote:
> to_timestamp is only for Oracle compatibility? I always thought it's
> some sort of sql standard. What's the sql compliant way to do this?

There isn't a standard method, which is why we added Oracle functions.

---------------------------------------------------------------------------


> 
> Regards,
> mario weilguni
> 
> 
> -----Urspr?ngliche Nachricht----- Von:
> pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] Im Auftrag von Tom Lane
> Gesendet: Freitag, 07. April 2006 06:09 An: Mario Weilguni Cc:
> PostgreSQL-development Betreff: Re: [HACKERS] Strange results from
> to_timestamp
> 
> Mario Weilguni <mweilguni@sime.com> writes:
> > I think all except the first one should raise a warning, isn't it?
> 
> to_timestamp (and friends) all seem to me to act pretty bizarre when
> faced with input that doesn't match the given format string.  However,
> in the end that is an Oracle-compatibility function, and there is only
> one measure of what it should do: what does Oracle do in the same case.
> Can anyone try these examples on a recent Oracle version?
> 
>         regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>       http://www.postgresql.org/docs/faq
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>   choose an index scan if your joining column's datatypes do not
>   match
> 

-- Bruce Momjian   http://candle.pha.pa.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Kevin Brown
Date:
Subject: Re: Corrupt data pages...
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Question on win32 semaphore simulation