Обсуждение: time default

Поиск
Список
Период
Сортировка

time default

От
Laurette Cisneros
Дата:
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...



Re: time default

От
Tom Lane
Дата:
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