time without time zone

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

Browse pgsql-hackers by date

  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...