Numeric won't store that :

        (+33) 4 01 23 45 67

On Wed, 11 Aug 2004 02:42:33 -0300, Er Galv„o Abbott <[EMAIL PROTECTED]> 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,




---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to