OSDir


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: NEQ-restriction in select-where clause


Hi,

You can only use IF = or IF != on insert, update or delete statements, it does not work on select. When using it, it will create a LWT transaction and you'll need full PK in the where condition, you can apply the IF on values of the row. For example:

update table set type = 'somethingelse' where pk='42' if type != 'something';

--
Jacques-Henri Berthemet

-----Original Message-----
From: Dmitry Lazurkin <dilaz03@xxxxxxxxx> 
Sent: Sunday, September 09, 2018 2:12 AM
To: dev@xxxxxxxxxxxxxxxxxxxx
Subject: NEQ-restriction in select-where clause

Hello.

Does it make sense to implement != restriction in select-where clause?
Is it possible?

Thank you.

PS. I want to implement that.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@xxxxxxxxxxxxxxxxxxxx
For additional commands, e-mail: dev-help@xxxxxxxxxxxxxxxxxxxx