Re: Problem search on text arrays, using the overlaps (&&) operator

From: John Cheng <jlcheng(at)ymail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem search on text arrays, using the overlaps (&&) operator
Date: 2009-07-07 22:52:33
Message-ID: 198949.19888.qm@web43401.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[])

?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vikram Patil 2009-07-08 00:04:16 Compiling using Visual Studio 2005
Previous Message Andreas Wenk 2009-07-07 19:32:01 Re: Sugestion a db modele like mysql workbrench