Re: Problem search on text arrays, using the overlaps (&&) operator - Mailing list pgsql-general

From John Cheng
Subject Re: Problem search on text arrays, using the overlaps (&&) operator
Date
Msg-id 198949.19888.qm@web43401.mail.sp1.yahoo.com
Whole thread Raw
In response to Problem search on text arrays, using the overlaps (&&) operator  (John Cheng <jlcheng@ymail.com>)
Responses Re: Problem search on text arrays, using the overlaps (&&) operator
List pgsql-general
I don't mean to be pesky. I was just wondering if there is anything
else I should try?

Should I simply rewrite all queries, change the form

WHERE textarr && '{foo, bar}'::text[]

To

WHERE (textarr && '{foo}'::text[]
       OR textarr && '{bar}'::text[])

?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general






pgsql-general by date:

Previous
From: Andreas Wenk
Date:
Subject: Re: Sugestion a db modele like mysql workbrench
Next
From: "Vikram Patil"
Date:
Subject: Compiling using Visual Studio 2005