Re: [HACKERS] Platform dependency in timestamp parsing

2001-10-19 Thread Thomas Lockhart
I've applied patches; all regression tests pass and the 'yyy-mm-ddThh:mm:ss' is now handled correctly afaict. There is an ongoing issue regarding precision and rounding for cases with large interval spans. I've patched the tree with a possible solution involving counting significant figures befor

Re: [HACKERS] Platform dependency in timestamp parsing

2001-10-19 Thread Thomas Lockhart
> Using current sources, the following sequence: > set DateStyle TO 'Postgres'; > set TimeZone TO 'PST8PDT'; > select '2001-09-22T18:19:20'::timestamp(2); > produces... (snip) ... > on my HPUX box, and evidently also on your machine because that's > what's in the timestamptz expected file. Howeve

[HACKERS] Platform dependency in timestamp parsing

2001-10-19 Thread Tom Lane
Using current sources, the following sequence: set DateStyle TO 'Postgres'; set TimeZone TO 'PST8PDT'; select '2001-09-22T18:19:20'::timestamp(2); produces timestamptz -- Sat Sep 22 11:19:20 2001 PDT on my HPUX box, and evidently also on your machine becau