| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: time default |
| Date: | 2002-09-14 15:20:26 |
| Message-ID: | 26901.1032016826@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Laurette Cisneros <laurette(at)nextbus(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-09-14 17:47:17 | Re: Multicolumn foreign keys need useless unique indices? |
| Previous Message | Tom Lane | 2002-09-14 15:14:23 | Re: Multicolumn foreign keys need useless unique indices? |