From: | Torbj=?ISO-8859-1?B?9g==?=rn Andersson <tobbe(at)embryo(dot)se> |
---|---|
To: | Charles Hauser <chauser(at)acpub(dot)duke(dot)edu>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Storing number '001' ? |
Date: | 2001-12-06 16:32:13 |
Message-ID: | B8355C1C.19FC%tobbe@embryo.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> Unfortunately, storing these numbers as integers converts 001 ->1,
> which I can't use.
>
> How does one store a number like '001'?
Store it as a varchar and use CAST when you select it.
Vänliga hälsningar
Torbjörn Andersson
---------------------------------------------------
Embryo Communication phone: +46 (0) 31-774 39 11(00)
Kungsgatan 7a fax: +46 (0)31 774 07 80
S-411 19 Göteborg mobile: 0708-30 70 04
Sweden home: http://www.embryo.se/
mail: torbjorn(dot)andersson(at)embryo(dot)se
---------------------------------------------------
"Att idag tänka annorlunda än igår skiljer den vise från den envise." John
Steinbeck
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-12-06 16:48:22 | Re: Storing number '001' ? |
Previous Message | daniel holtzman | 2001-12-06 07:00:49 | multiple joins |