any with the output of coalesce

From: SunWuKung <Balazs(dot)Klein(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: any with the output of coalesce
Date: 2007-09-20 09:24:13
Message-ID: 1190280253.743274.208230@o80g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-09-20 10:07:09 Re: Postgresql and SSL
Previous Message Jorge Godoy 2007-09-20 08:42:35 Re: Postgresql and SSL