"posttime" time DEFAULT now()

From: "Koen Antonissen" <Koen(at)Cee-Kay(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: "posttime" time DEFAULT now()
Date: 2001-11-22 13:30:15
Message-ID: DD782DD61CF86144BD78DDC89D3D6124083BAC@gaea.home.dutchcentral.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

"posttime" time DEFAULT now()

I'm declaring a field called posttime (see above), which ofcourse stores
the time of a certain posting. It's nice to use a default value as
now(). But unfourtunatly, while creating the table, it generates the
following error:

ERROR: Column "posttime" is of type time without time zone but default
expression is of type timestamp with time zone
You will need to rewrite or cast the expression

I prefer to ignore the timezone information... any hints?

NOTE: I've updated from 7.1 to 7.2b2 and before there was no problem
like this (exact same table existed on 7.1).

Thanks,
Koen Antonissen

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marc G. Fournier 2001-11-22 14:41:53 INDEXng date_trunc ...
Previous Message Hervé Piedvache 2001-11-22 11:57:33 How are working index with date ?