From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | BUG?: timestamp without TZ created as timestamp *with* TZ |
Date: | 2002-08-29 13:39:24 |
Message-ID: | 3D6E240C.70505@mega-bucks.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jules Alberts | 2002-08-29 13:47:14 | Re: Securing sensitive information |
Previous Message | Tom Lane | 2002-08-29 13:29:38 | Re: Free space mapping (was Re: Multi-Versions and Vacuum) |