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 <[email protected]> Sent: Sunday, September 09, 2018 2:12 AM To: [email protected] 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: [email protected] For additional commands, e-mail: [email protected]
