Re: time default - Mailing list pgsql-hackers

From Tom Lane
Subject Re: time default
Date
Msg-id 26901.1032016826@sss.pgh.pa.us
Whole thread Raw
In response to time default  (Laurette Cisneros <laurette@nextbus.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multicolumn foreign keys need useless unique indices?
Next
From: Tom Lane
Date:
Subject: Casting rules (was: an untitled thread)