Allow field values in UPDATE OR INSERT in "Values" clause
----------------------------------------------------------
Key: CORE-3456
URL: http://tracker.firebirdsql.org/browse/CORE-3456
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 2.1.4
Reporter: Karol Bieniaszewski
Priority: Minor
normally update statement allow somethink like this
update table1 set field1 = coalesce(field1, 0) + 1 where id=5
but
UPDATE OR INSERT INTO table1(id, field1) VALUES(5, coalesce(field1, 0) + 1)
MATCHING (ID)
is not possible
now only solution is
UPDATE OR INSERT INTO table1(id, field1) VALUES(5, coalesce(
(SELECT field1 FROM table1 where id=5)
, 0) + 1) MATCHING (ID)
and the same select for other fields
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
