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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: anoncvs failure...
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: time without time zone