From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | time without time zone |
Date: | 2001-09-26 08:57:35 |
Message-ID: | ECEHIKNFIMMECLEBJFIGIEBOCCAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 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
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2001-09-26 08:58:52 | time without time zone |
Previous Message | Bruce Momjian | 2001-09-26 07:43:13 | Re: anoncvs failure... |