By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 4
| ts_id | ts | tz | tstz_literal | tstz |
|---|---|---|---|---|
| 1 | 2013-11-28 23:09:11.761166 | +03 | 2013-11-28 23:09:11.761166+03 | 2013-11-28 20:09:11.761166+00 |
| 2 | 2013-11-28 23:09:11.761166 | CET | 2013-11-28 23:09:11.761166 CET | 2013-11-28 22:09:11.761166+00 |
| 3 | 2013-11-28 23:09:11.761166 | America/New_York | 2013-11-28 23:09:11.761166 America/New_York | 2013-11-29 04:09:11.761166+00 |
| 4 | 2013-11-28 23:09:11.761166 | 2013-11-28 23:09:11.761166 | 2013-11-28 23:09:11.761166+00 |
SELECT 4