Re: [firebird-support] What is more effective execute block or select?

 

On Thu, 28 Jan 2016 16:22:03 +0100, "Svein Erling Tysvær
setysvar@gmail.com
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> No, I must admit limited knowledge of MERGE. For Firebird 3 is seems
like a
> good alternative, but I think Fb 2.1 and 2.5(?) requires a WHEN NOT
MATCHED
> THEN INSERT clause (which is typically not desirable in these cases).

I don't have a Firebird install available right now, but looking at the
syntax file (parse.y), the WHEN NOT MATCHED THEN INSERT clause is not
required, not in 2.1 nor in 2.5. The syntax in the language reference
suggests it is required, but as far as I can see it isn't.

Mark

__._,_.___

---

Posted by: Mark Rotteveel <mark@lawinegevaar.nl>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___