"posttime" time DEFAULT now()

Поиск
Список
Период
Сортировка
От Koen Antonissen
Тема "posttime" time DEFAULT now()
Дата
Msg-id DD782DD61CF86144BD78DDC89D3D6124083BAC@gaea.home.dutchcentral.net
обсуждение исходный текст
Ответы Re: "posttime" time DEFAULT now()  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Hervé Piedvache
Дата:
Сообщение: How are working index with date ?
Следующее
От: Andriy Pyrozhenko
Дата:
Сообщение: Question