Thanks Pawel! Another item checked off our wish list!
Giraldo
On Monday, February 10, 2014 5:15:56 PM UTC-5, Lvc@ wrote:
>
> Hi,
>
> Pawel just contributed by providing the new UPSERT feature on SQL UPDATE
> command. Below the Pawel's comments:
>
> "UPSERT update a record if it already exists, or insert a new record if it
> does not - all in a single statement. It should decreases time of data
> insertion, where the scenario
>
> if( SELECT record exists ) {
> UPDATE record;
> } else {
> INSERT record;
> }
>
> is common. UPSERT operator has a sense with class name and WHERE operator.
> In other cases generates an exception.
>
> Full UPDATE syntax would look following:
>
> UPDATE |cluster:> [SET|ADD|PUT|REMOVE|INCREMENT|CONTENT {}|MERGE {}] [[,]
> = |]* [LOCK ] [UPSERT] [RETURN ] [WHERE]"
>
> It's already available in OrientDB 1.7-rc2-SNAPSHOT (or "develop" branch).
>
> Thank you Pawel, hope other users will follow you by contributing with
> such good Pull Requests!
>
> Lvc@
>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
