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 по дате отправления:

Предыдущее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: NUMERIC x VARCHAR
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: NUMERIC x VARCHAR