time without time zone - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject time without time zone
Date
Msg-id ECEHIKNFIMMECLEBJFIGIEBOCCAA.chriskl@familyhealth.com.au
Whole thread Raw
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: anoncvs failure...
Next
From: "Christopher Kings-Lynne"
Date:
Subject: time without time zone