Tim Kane <tim.kane@gmail.com> wrote:
> I'm using a single LIKE clause against an array parameter, rather
> than multiple LIKE clauses against a single parameter.
The problem is that you have the arguments to the LIKE parameter
reversed with the attempts you show. Try something like this:
select * from ids
where exists
(select * from (select unnest(ids.id)) x(id)
where x.id like 's45%');
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company