Commented by: Alice F. Bird (firebirds)

Date: 2005-11-14 11:22
Sender: lacak
Logged In: YES
user_id=1189292

I would like to ask if this will be done before finall FB 2.0 ?
Or after FB 2.0 or never ? :-)
FB 2 is in beta state.
Is beta 1 feature completed or new features will be added until
FB 2 finall release ?
Thanks.

Commented by: Alice F. Bird (firebirds)

Date: 2005-11-14 11:22
Sender: lacak
Logged In: YES
user_id=1189292

Your Feature Request has already been been recorded in the
tracker database. Accordingly, your request has been deleted,
since it is a duplicate request.

Additionally, we currently don't use the SF Feature Request
manager. So if you have any further feature requests, they
should be posted to the SF bug tracker, and assigned to
the "Feature Request" Group.

Thanks for your interest in the project.

Commented by: lacak (lacak)

MySQL:
------
DELETE <table>[, <table> ...]
FROM <table_references>
WHERE <where definition>

DELETE FROM <table>[, <table> ...]
USING <table_references>
WHERE <where definition>

UPDATE <table>[, <table> ...]
SET ...
WHERE <where definition>

PostgreSQL:
-----------
DELETE FROM <table>
WHERE table1.col1=table2.col1 ...

UPDATE <table>
SET ...
FROM <table2>[, <table3> ...]
WHERE ...

MSSQL:
------
DELETE [FROM] <table>
FROM <table source>
WHERE ...

UPDATE <table>
SET ...
FROM <table source>
WHERE ...

Oracle:
-------
DELETE FROM <table source>
WHERE ...

DELETE FROM (select * from <table>)
WHERE ...

UPDATE <table source>
SET col=expr[, (col1,col2)=(<subquery>) ...]
WHERE ...

Oracle syntax is very clever ... is not ?

Commented by: lacak (lacak)

MERGE statement introduced in 2.1 provides this functionality

MERGE INTO table1 USING table2 ON table1.c1=table2.c1
WHEN MATCHED THEN UPDATE SET ...

which is similar to

UPDATE table1 SET ... FROM <table2> WHERE table1.c1=table2.c1

so I think, that this FR-758 is obsolete, is not ?

ORACLE and IBM DB2 have interesting extension to SQL2003 :

WHEN MATCHED [AND <search condition>] THEN [UPDATE SET ... | DELETE ]

which enables INSERT not matched rows or UPDATE or DELETE matched rows

Commented by: @asfernandes

Yes, you're right.
And these extensions seems good IMO, for future versions.

Commented by: Sean Leyne (seanleyne)

Closed at the request of the case reporter.