(not) quoting float8 and numeric
От
Stefan Waidele jun.
Тема
(not) quoting float8 and numeric
Дата
Msg-id
5.0.2.1.0.20010205223849.00a8c6e8@imap.Krone-Neuenburg.de
Список
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
В списке pgsql-novice по дате отправления