time without time zone
От | Christopher Kings-Lynne |
---|---|
Тема | time without time zone |
Дата | |
Msg-id | ECEHIKNFIMMECLEBJFIGIEBOCCAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Список | pgsql-hackers |
In 7.1.3, you can create a column as "time without time zone", but it doesn't seem to show as such in psql... eg: test=# alter table chat_meetings add column timeofday time without time zone; ALTER test=# \d chat_meetings Table "chat_meetings"Attribute | Type | Modifier ------------+------------------------+-------------------------------------- ------ --------------------meeting_id | integer | not null default nextval('chat_meetings_mee ting_id_seq'::text)host_id | integer | not nulltitle | character varying(255) | not nullabstract | text | not nulltime | integer | not nulldayofweek | smallint |timeofday | time | Indices: chat_meetings_pkey, host_id_chat_meetings_key There's no easy way of seeing what exact type the column is it seems. Chris
В списке pgsql-hackers по дате отправления: