Re: [HACKERS] Binary timestamp with without timezone

2010-12-20 Thread Merlin Moncure
On Mon, Dec 20, 2010 at 6:29 AM, Radosław Smogura wrote: > > On Thu, 16 Dec 2010 14:24:27 -0500, Tom Lane wrote: >> >> =?utf-8?q?Rados=C5=82aw_Smogura?= writes: >>> >>> Tom Lane Thursday 16 December 2010 18:59:56 =?utf-8?q?Rados=C5=82aw_Smogura?= writes: > > ... This timestam

Re: [HACKERS] Binary timestamp with without timezone

2010-12-20 Thread Radosław Smogura
On Thu, 16 Dec 2010 14:24:27 -0500, Tom Lane wrote: =?utf-8?q?Rados=C5=82aw_Smogura?= writes: Tom Lane Thursday 16 December 2010 18:59:56 =?utf-8?q?Rados=C5=82aw_Smogura?= writes: ... This timestamp must be properly encoded depending if target is WITH TZ or not, but JDBC (and other clien

Re: [HACKERS] Binary timestamp with without timezone

2010-12-16 Thread Tom Lane
=?utf-8?q?Rados=C5=82aw_Smogura?= writes: > Tom Lane Thursday 16 December 2010 18:59:56 >> =?utf-8?q?Rados=C5=82aw_Smogura?= writes: >>> ... This timestamp must be properly encoded >>> depending if target is WITH TZ or not, but JDBC (and other clients, >>> probably too) doesn't have any knowledg

Re: [HACKERS] Binary timestamp with without timezone

2010-12-16 Thread Radosław Smogura
Tom Lane Thursday 16 December 2010 18:59:56 > =?utf-8?q?Rados=C5=82aw_Smogura?= writes: > > I work on binary support for JDBC. I saw disadventage of TIMESTAMPS WITH > > / WITHOUT TZ. Currently (in text mode) driver always sends date time > > string with appended time offset, as UNSPECIFIED so bac

Re: [HACKERS] Binary timestamp with without timezone

2010-12-16 Thread Tom Lane
=?utf-8?q?Rados=C5=82aw_Smogura?= writes: > I work on binary support for JDBC. I saw disadventage of TIMESTAMPS WITH / > WITHOUT TZ. Currently (in text mode) driver always sends date time string > with > appended time offset, as UNSPECIFIED so backend can choose to use offset or > not. In bina

[HACKERS] Binary timestamp with without timezone

2010-12-16 Thread Radosław Smogura
Hi, I work on binary support for JDBC. I saw disadventage of TIMESTAMPS WITH / WITHOUT TZ. Currently (in text mode) driver always sends date time string with appended time offset, as UNSPECIFIED so backend can choose to use offset or not. In binary mode I can only send 8 bytes timestamp withou