From: | "Stefan Waidele jun(dot)" <St(dot)Waidele(dot)jun(at)Krone-Neuenburg(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | (not) quoting float8 and numeric |
Date: | 2001-02-05 21:46:37 |
Message-ID: | 5.0.2.1.0.20010205223849.00a8c6e8@imap.Krone-Neuenburg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello again,
I have a problem with Delphi and Postgres (not) working together.
Using the Delphi-Components to acces my tables, I get an error whenever I
have a float or numeric field.
When updating a record, the generates SQL-Statement does not have the
values quoted.
I have asked in a Delphi-Newsgroup how/if I can change that.
Just in case it is not possible: Can I tweak Postgres to less picky about
the quotes?
The query looks like:
UPDATE inv_artikel SET bezeichnung='Asbach Uralt' WHERE nr=1 AND
bezeichnung='Asbach Uralt' AND gebinde='Flasche' AND inhalt='3 ltr' AND
anzahl=1 AND preis=81.45 AND gruppe='sp' AND subgruppe='' AND anz=1
---> ERROR: Unable to identify an operator '=' for types 'numeric' and
'float8' You will have to retype this query using an explicit cast
Thanks,
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | GH | 2001-02-05 22:02:09 | Re: When replication? |
Previous Message | Glenn Holmer | 2001-02-05 20:47:23 | Re: PGSQL Hosting providers? |