From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
---|---|
To: | galvao(at)galvao(dot)eti(dot)br |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: NUMERIC x VARCHAR |
Date: | 2004-08-11 07:41:25 |
Message-ID: | D909485D-EB69-11D8-831D-000A95C88220@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Aug 11, 2004, at 4:27 PM, Er Galvão Abbott wrote:
> It will. As I've said I wont be storing any symbols.
It won't store leading zeros, however. This may or may not be an issue
for you.
test=# create table tel (name_id integer not null, tel_numeric
numeric(15) not null, tel_varchar varchar(15) not null);
CREATE TABLE
test=# insert into tel (name_id, tel_numeric, tel_varchar) values
(1,012345678911234, '012345678911234');
INSERT 17153 1
test=# select * from tel;
name_id | tel_numeric | tel_varchar
---------+----------------+-----------------
1 | 12345678911234 | 012345678911234
(1 row)
I would do as another poster suggested: create a telephone number
domain as text with the check constraints you desire.
Michael Glaesemann
grzm myrealbox com
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2004-08-11 12:21:33 | Re: Hardware upgrade for a high-traffic database |
Previous Message | Er Galvão Abbott | 2004-08-11 07:27:31 | Re: NUMERIC x VARCHAR |