Thank you very much !
I have another question for datetime type, it is GUC parameter 'timezone' , example as follow:
postgres=# set timezone='-08:00';
SET
postgres=# show timezone;
TimeZone
----------
-08:00
(1 row)
postgres=# select timestamptz'1990-1-1 11:11:11.123 -08:00' ;
timestamptz
----------------------------
1990-01-02 03:11:11.123+08
(1 row)
postgres=# select timestamptz'1990-1-1 11:11:11.123 +08:00' ;
timestamptz
----------------------------
1990-01-01 11:11:11.123+08
(1 row)
postgres=#
this looks like, the sign plus and minus are inverted, i dont understand why?
在 2016-08-04 23:06:40,"David G. Johnston" <david.g.johnston@gmail.com> 写道: