Re: NUMERIC x VARCHAR

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: NUMERIC x VARCHAR
Date: 2004-08-11 06:47:10
Message-ID: opscj2gwgscq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Numeric won't store that :

(+33) 4 01 23 45 67

On Wed, 11 Aug 2004 02:42:33 -0300, Er Galvão Abbott
<galvao(at)galvao(dot)eti(dot)br> wrote:

> Greetings.
>
> I have a question regarding performance of certain datatypes:
>
> I have a field where I will store my clients phone numbers. I know that
> this
> field will never exceed 15 characters, and I will store only numbers
> here (no
> dashes, dots, etc...), so I was wondering:
>
> Wich type is faster: NUMERIC(15,0) or VARCHAR(15)? Are there any storage
> differences between them?
>
> TIA,
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Er Galvão Abbott 2004-08-11 07:27:31 Re: NUMERIC x VARCHAR
Previous Message Pierre-Frédéric Caillaud 2004-08-11 06:43:36 Re: Hardware upgrade for a high-traffic database