You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Make it possible to access field values in VALUES statement if it is UPDATE, if INSERT then values can be NULL. That would make this possible:
UPDATE OR INSERT INTO table1 ( http://table1.id,
table1.code, http://table1.name
) VALUES (
COALESCE(http://table1.id, NEXT VALUE FOR ID),
'007',
'James'
) MATCHING (
table1.code
);
The text was updated successfully, but these errors were encountered:
description: Make it possible to access field values in VALUES statement if it is UPDATE, if INSERT then values can be NULL. That would make this possible:
UPDATE OR INSERT INTO table1 ( http://table1.id,
table1.code, http://table1.name
) VALUES (
COALESCE(http://table1.id, gen_id(id)),
'007',
'James'
) MATCHING (
table1.code
);
=>
Make it possible to access field values in VALUES statement if it is UPDATE, if INSERT then values can be NULL. That would make this possible:
UPDATE OR INSERT INTO table1 ( http://table1.id,
table1.code, http://table1.name
) VALUES (
COALESCE(http://table1.id, NEXT VALUE FOR ID),
'007',
'James'
) MATCHING (
table1.code
);
Primary key is not relevant to this feature, but lets say PK is on ID field. This is another use example:
UPDATE OR INSERT INTO babies ( http://babies.id,
babies.age, http://babies.name
) VALUES (
COALESCE(http://babies.id, NEXT VALUE FOR ID),
COALESCE(babies.age + 1, 1),
'James'
) MATCHING ( http://babies.name
);
Submitted by: Jonas Jasas (jon)
Make it possible to access field values in VALUES statement if it is UPDATE, if INSERT then values can be NULL. That would make this possible:
UPDATE OR INSERT INTO table1 (
http://table1.id,
table1.code,
http://table1.name
) VALUES (
COALESCE(http://table1.id, NEXT VALUE FOR ID),
'007',
'James'
) MATCHING (
table1.code
);
The text was updated successfully, but these errors were encountered: