bruehlicke <bruehlicke@gmail.com> writes:

> I have a trigger something like
>
> ..... UPDATE X SET A=(SELECT ..... )
>
>
> Now, if the embedded SELECT statement returns no rows I would NOT like
> to change the value from A to "bank/null" but let it keep the value it
> currently has.
>
> Any suggestions for a one liner which fits into a create trigger statement

I think this should do the trick:

UPDATE X SET A=COALESCE((SELECT ......), A)

-- 
Knut Anders