Re: [BUGS] BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior

2009-11-16 Thread Thomas S. Chin
Thanks Tom ... appreciate the clarification. Have a good day. thom Tom Lane wrote: "Thomas S. Chin" writes: Description:--disable-integer-datetimes changes timestamp comparison behavior This is not a bug. Float timestamps are inherently not infinitely precise, but your

[BUGS] BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior

2009-11-16 Thread Thomas S. Chin
The following bug has been logged online: Bug reference: 5192 Logged by: Thomas S. Chin Email address: t...@photoshelter.com PostgreSQL version: 8.4.1 Operating system: Linux 2.6.28-hardened-r9-bitshelter #6 SMP x86_64 Intel(R) Xeon(R) Description:--disable-integer

Re: [BUGS] BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)

2009-04-24 Thread Thomas S. Chin
Ah, okay, found the documentation mentioning this (LIMIT). I was looking in the wrong place (ORDER BY clause). Thanks again for the help. Tom Lane wrote: "Thomas S. Chin" writes: I noticed that the behavior of queries that involve LIMIT/OFFSET no longer return results consisten

[BUGS] BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)

2009-04-24 Thread Thomas S. Chin
The following bug has been logged online: Bug reference: 4779 Logged by: Thomas S. Chin Email address: t...@genx.net PostgreSQL version: 8.3.7 Operating system: Linux tat 2.6.27-gentoo-r7 #1 SMP Fri Jan 2 08:50:09 EST 2009 i686 Intel(R) Core(TM)2 CPU 6700 @ 2.66GHz