Re: NUMERIC x VARCHAR
От | Er Galvão Abbott |
---|---|
Тема | Re: NUMERIC x VARCHAR |
Дата | |
Msg-id | 4119CA63.8050307@galvao.eti.br обсуждение исходный текст |
Ответ на | Re: NUMERIC x VARCHAR (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>) |
Ответы |
Re: NUMERIC x VARCHAR
|
Список | pgsql-performance |
<font face="Verdana">It will. As I've said I wont be storing any symbols.<br /><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><br /><br /> Pierre-FrédéricCaillaud wrote:<br /><blockquote cite="midopscj2gwgscq72hf@musicbox" type="cite"><br /> Numeric won't storethat : <br /><br /> (+33) 4 01 23 45 67 <br /><br /> On Wed, 11 Aug 2004 02:42:33 -0300, Er Galvão Abbott <a class="moz-txt-link-rfc2396E"href="mailto:galvao@galvao.eti.br"><galvao@galvao.eti.br></a> wrote: <br /><br /><blockquotetype="cite">Greetings. <br /><br /> I have a question regarding performance of certain datatypes: <br /><br/> I have a field where I will store my clients phone numbers. I know that this <br /> field will never exceed 15 characters,and I will store only numbers here (no <br /> dashes, dots, etc...), so I was wondering: <br /><br /> Wich typeis faster: NUMERIC(15,0) or VARCHAR(15)? Are there any storage <br /> differences between them? <br /><br /> TIA, <br/><br /></blockquote><br /><br /><br /> ---------------------------(end of broadcast)--------------------------- <br />TIP 6: Have you searched our list archives? <br /><br /> <a class="moz-txt-link-freetext" href="http://archives.postgresql.org">http://archives.postgresql.org</a><br/><br /><br /></blockquote><br /><pre class="moz-signature"cols="72"> </pre>
В списке pgsql-performance по дате отправления: