time default

Started by Laurette Cisnerosover 23 years ago2 messages
#1Laurette Cisneros
laurette@nextbus.com

In 7.3

Is this default for data type time also without timezone now?

Thanks,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
A wiki we will go...

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Laurette Cisneros (#1)
Re: time default

Laurette Cisneros <laurette@nextbus.com> writes:

In 7.3
Is this default for data type time also without timezone now?

AFAIR it always was.

test72=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.2.2 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)

test72=# create table foo (f1 time);
CREATE
test72=# \d foo
Table "foo"
Column | Type | Modifiers
--------+------------------------+-----------
f1 | time without time zone |

regards, tom lane