NUMERIC x VARCHAR
От | Er Galvão Abbott |
---|---|
Тема | NUMERIC x VARCHAR |
Дата | |
Msg-id | 4119B1C9.2010800@galvao.eti.br обсуждение исходный текст |
Ответы |
Re: NUMERIC x VARCHAR
Re: NUMERIC x VARCHAR |
Список | pgsql-performance |
<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 по дате отправления: