| 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: | Whole Thread | Raw Message | 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 |