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