From: | ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca |
---|---|
To: | FMK <meyer-kassel(at)online-shop-ag(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Re[2]: Problems with varchar/text |
Date: | 2000-08-30 14:06:46 |
Message-ID: | Pine.A41.3.95.1000830080134.33064C-100000@freenet.edmonton.ab.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 30 Aug 2000, FMK wrote:
> I'm using ColdFusion with a native PostgreSQL-Driver. OS is Linux, and
> my insert-statement looks like this:
>
> INSERT INTO billing (billnumber) VALUES (00086901)
>
> > Maybe you have forgot to quote the string.
> > Could you mail us the exact SQL that you use to insert the data.
Your answer is right there. Most languages are going to
see your INSERT statement as:
INSERT INTO billing (billnumber) VALUES (some_number)
If you want to insert a string, you need to quote it:
INSERT INTO billing (billnumber) VALUES ("00086901")
I don't know if you need double quotes, single quotes or
something else. They are quite often different (certainly
they are using the perl-postgres interface, which is what
I have some experience with).
But your interpretter is seeing a number (00086901) with leading,
insignificant zeros. It is deleting those zeros before executing
the statement. Just like 9.0000000000000000000000000000000000000
gets executed as 9.
Gord
Matter Realisations http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101 9504 182 St. NW Edmonton, AB, CA T5T 3A7
780/481-8019 ghaverla @ freenet.edmonton.ab.ca
From | Date | Subject | |
---|---|---|---|
Next Message | FMK | 2000-08-30 14:16:34 | Re[2]: Problems with varchar/text |
Previous Message | Poul L. Christiansen | 2000-08-30 14:04:59 | Re: Problems with varchar/text |