mboes@tweag.net writes: > Is there a way of specifying the precision of a timestamp *with > timezone* field? It works fine for timestamps *without* timezone It's timestamp(n) with time zone timestamp(n) without time zone and not any other variants that might seem natural. Don't blame us, that's what the SQL standard says ;-) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html