Postgres Pro
Downloads
Home   >   mailing lists

NUMERIC x VARCHAR - Mailing list pgsql-performance

From Er Galvão Abbott
Subject NUMERIC x VARCHAR
Date
Msg-id 4119B1C9.2010800@galvao.eti.br
Whole thread Raw
Responses Re: NUMERIC x VARCHAR  ("Scott Marlowe" <smarlowe@qwest.net>)
Re: NUMERIC x VARCHAR  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
List pgsql-performance
Tree view 
<font face="Verdana">Greetings.<br /><br /> I have a question regarding performance of certain datatypes:<br /><br /> I
havea field where I will store my clients phone numbers. I know that this field will never exceed 15 characters, and I
willstore only numbers here (no dashes, dots, etc...), so I was wondering:<br /><br /> Wich type is faster:
NUMERIC(15,0)or VARCHAR(15)? Are there any storage differences between them?<br /><br /> TIA,<br /></font> <pre
class="moz-signature"cols="72">-- 
 
Er Galvão Abbott
Desenvolvedor Web
<a class="moz-txt-link-freetext" href="http://www.galvao.eti.br/">http://www.galvao.eti.br/</a>
<a class="moz-txt-link-abbreviated" href="mailto:galvao@galvao.eti.br">galvao@galvao.eti.br</a></pre>

pgsql-performance by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: Bulk Insert and Index use
Next
From: "Scott Marlowe"
Date:
Subject: Re: NUMERIC x VARCHAR