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 по дате отправления: