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 null
 title      | character varying(255) | not null
 abstract   | text                   | not null
 time       | integer                | not null
 dayofweek  | 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


Wed, 26 Sep 2001 16:57:35 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
time without time zone