Re: [Haskelldb-users] Problem using CalendarTimeT column

[Colin P. A. <co...@co...>]

>>>>> "Colin" == Colin Paul Adams <co...@co...> writes:

>>>>> "Colin" == Colin Paul Adams <co...@co...> writes:
    Colin> It is just the code to generate the SQL for CREATE TABLE is
    Colin> presumably faulty. For CalendarTimeT columns it should
    Colin> generate a time of

    Colin> timestamp with time zone

    Colin> as CalendarTime is a zoned timestamp.

here's my patch:

--- Default.hs~	2009-02-13 23:06:25.000000000 +0000
+++ Default.hs	2009-10-01 16:43:34.000000000 +0100
@@ -92,7 +92,7 @@
       IntegerT      -> SqlType "bigint"
       DoubleT       -> SqlType "double precision"
       BoolT         -> SqlType "bit"
-      CalendarTimeT -> SqlType "timestamp"
+      CalendarTimeT -> SqlType "timestamp with time zone"
       BStrT a       -> SqlType1 "varchar" a

-- 
Colin Adams
Preston Lancashire