BUG?: timestamp without TZ created as timestamp *with* TZ
| От | Jean-Christian Imbeault |
|---|---|
| Тема | BUG?: timestamp without TZ created as timestamp *with* TZ |
| Дата | |
| Msg-id | 3D6E240C.70505@mega-bucks.co.jp обсуждение исходный текст |
| Ответы |
Re: BUG?: timestamp without TZ created as timestamp *with* TZ
|
| Список | pgsql-general |
It seems that even though I declare a columns to be of type timestamp
without time zone it gets created as a data type *with* a time zone?
Did I miss something?
Here my SQL:
create table MEMBERS (
id serial primary key,
login text unique not null,
first_name char(64) not null,
last_name char(64) not null,
first_name_kana char(64) not null,
last_name_kana char(64) not null,
primary_email text not null,
pw_hash text not null,
membership_type integer references MEMBERSHIP_TYPES(id),
sex char(1) ,
dob date ,
payment_type integer references PAYMENT_TYPES(id),
last_login timestamp without time zone [0],
disabled boolean default true
);
I then do a "\d members" and get:
Column | Type |
Modifiers
-----------------+----------------------------+----------------------------------------------------
id | integer | not null default
nextval('"members_id_seq"'::text)
login | text | not null
first_name | character(64) | not null
last_name | character(64) | not null
first_name_kana | character(64) | not null
last_name_kana | character(64) | not null
primary_email | text | not null
pw_hash | text | not null
membership_type | integer |
sex | character(1) |
dob | date |
payment_type | integer |
last_login | timestamp with time zone[] |
disabled | boolean | default 't'::bool
Primary key: members_pkey
Unique keys: members_login_key
Triggers: RI_ConstraintTrigger_2169213,
RI_ConstraintTrigger_2169219
В списке pgsql-general по дате отправления: