Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group