(not) quoting float8 and numeric

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

Browse pgsql-novice by date

  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?