OSDir


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

Re: NEQ-restriction in select-where clause


Yes, but I need for select ;-)

пн, 10 сент. 2018 г., 11:03 Jacques-Henri Berthemet <
jacques-henri.berthemet@xxxxxxxxxxx>:

> 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
>
>