Re: [BUGS] to_timestamp not stable if date string shorter than template

2003-09-05 Thread Mendola Gaetano
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> Newsgroups: comp.databases.postgresql.bugs Sent: Wednesday, September 03, 2003 1:05 AM Subject: Re: to_timestamp not stable if date string shorter than template > "Stacy White" <[EMAIL PROTECTED]> writes: > > to_timestamp appears

Re: [BUGS] to_timestamp not stable if date string shorter than

2003-09-03 Thread Karel Zak
On Wed, Sep 03, 2003 at 12:03:59AM -0400, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > I don't entirely understand all of what that code is doing, but I think > > there's something in there that needs to get fixed. > > Oh-ho, this is interesting: > > Build CVS tip on RHL 8.0 wi

Re: [BUGS] to_timestamp not stable if date string shorter than

2003-09-02 Thread Stephan Szabo
On Wed, 3 Sep 2003, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > Replying to myself again: > > In DCH_processor (formatting.c), it doesn't seem to stop if it's in the > > middle of processing nodes but runs off the inout string, should the for > > loop be something like: > > fo

Re: [BUGS] to_timestamp not stable if date string shorter than

2003-09-02 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > Replying to myself again: > In DCH_processor (formatting.c), it doesn't seem to stop if it's in the > middle of processing nodes but runs off the inout string, should the for > loop be something like: > for (n=node,s=inout;n->type!=NODE_TYPE_END && *s!='

Re: [BUGS] to_timestamp not stable if date string shorter than

2003-09-02 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > I don't entirely understand all of what that code is doing, but I think > there's something in there that needs to get fixed. Oh-ho, this is interesting: Build CVS tip on RHL 8.0 with --enable-cassert: no bug. Build CVS tip on RHL 8.0 without --enable-

Re: [BUGS] to_timestamp not stable if date string shorter than

2003-09-02 Thread Stephan Szabo
On Tue, 2 Sep 2003, Stephan Szabo wrote: > On Tue, 2 Sep 2003, Stephan Szabo wrote: > > > > > On Tue, 2 Sep 2003, Tom Lane wrote: > > > > > "Stacy White" <[EMAIL PROTECTED]> writes: > > > > to_timestamp appears to pick up the time-of-day from the previous call's > > > > return value if a date stri

Re: [BUGS] to_timestamp not stable if date string shorter than

2003-09-02 Thread Stephan Szabo
On Tue, 2 Sep 2003, Stephan Szabo wrote: > > On Tue, 2 Sep 2003, Tom Lane wrote: > > > "Stacy White" <[EMAIL PROTECTED]> writes: > > > to_timestamp appears to pick up the time-of-day from the previous call's > > > return value if a date string has no time component. For example: > > > > Weird. I

Re: [BUGS] to_timestamp not stable if date string shorter than

2003-09-02 Thread Stephan Szabo
On Tue, 2 Sep 2003, Tom Lane wrote: > "Stacy White" <[EMAIL PROTECTED]> writes: > > to_timestamp appears to pick up the time-of-day from the previous call's > > return value if a date string has no time component. For example: > > Weird. I do not see that here, on either 7.3.4 or current source

Re: [BUGS] to_timestamp not stable if date string shorter than template

2003-09-02 Thread Tom Lane
"Stacy White" <[EMAIL PROTECTED]> writes: > to_timestamp appears to pick up the time-of-day from the previous call's > return value if a date string has no time component. For example: Weird. I do not see that here, on either 7.3.4 or current sources. Can anyone else reproduce it? For the recor

[BUGS] to_timestamp not stable if date string shorter than template

2003-09-02 Thread Stacy White
Architecture: Intel Pentium Operating System: Redhat 7.2 (Linux 2.4.17) PostgreSQL version: PostgreSQL-7.3.4 Compiler used: gcc 3.01 to_timestamp appears to pick up the time-of-day from the previous call's return value if a date string has no time component. For example: # select to_timestamp('2