Re: NUMERIC x VARCHAR - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: NUMERIC x VARCHAR
Date
Msg-id opscj2gwgscq72hf@musicbox
Whole thread Raw
In response to NUMERIC x VARCHAR  (Er Galvão Abbott <galvao@galvao.eti.br>)
Responses Re: NUMERIC x VARCHAR
List 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@galvao.eti.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,
>



pgsql-performance by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Hardware upgrade for a high-traffic database
Next
From: Er Galvão Abbott
Date:
Subject: Re: NUMERIC x VARCHAR