timestamp precision with or without timezones

From: mboes(at)tweag(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: timestamp precision with or without timezones
Date: 2004-04-06 22:16:53
Message-ID: 20040406221653.GA20635@dell.wanadoo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

Is there a way of specifying the precision of a timestamp *with
timezone* field? It works fine for timestamps *without* timezones, but
gives me a syntax error if I try with timestamptz:

tweag=> create table tbl1 (t timestamp(0));
CREATE TABLE
tweag=> \d tbl1
Table "public.tbl1"
Column | Type | Modifiers
--------+--------------------------------+-----------
t | timestamp(3) without time zone |

tweag=> create table tbl1 (t timestamptz(0));
ERROR: syntax error at or near "(" at character 33
tweag=> create table tbl1 (t timestamp(0) without timezone);
ERROR: syntax error at or near "timezone" at character 43

TIA,

Mathieu Boespflug

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry LeVan 2004-04-06 22:25:28 Tcl load command and mac os x
Previous Message CSN 2004-04-06 21:57:36 Logging database and statement with errors