Tim Kane <tim.k...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
