I am trying to create an expression which
- always yield true if the incomming array is NULL
- yields true if a given value is in the array, otherwise yields false
I thought this should work:
Select 'target'=ANY(COALESCE('{indata1, indata2}','{target}'))
but I get an ERROR: op ANY/ALL (array) requires array on right side
Can somebody tell me what I am doing wrong and how to do this right?
Thanks for the help.
Balázs
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
