Hi
well it's pretty simple
if you want to see if there are elements in common then instead of "any" use
"&&"
if you want to see if they are equal just use " = " that will five you true
or false
you can check array functions in here
http://www.postgresql.org/docs/8.2/static/functions-array.htm
hum thanks a lot for the quick answer,
if is not abuse of your patience
what is the best alternative to the LEFT OUTER JOINS?
RC
On Wed, Jul 1, 2009 at 6:12 PM, Mike Ivanov wrote:
> > Merge Join (cost=111885.70..319492.88 rows=13016048 width=620)
>
> The outermost merge join has to go throu
HI Gurus ,
i have this query (i think is a simple one)
it takes me 1,7s to run it, it's not to long, but considering it takes 1,7s
to return 71lines makes me wonder... is there anyother way to do this, on a
first look??
any sugestion would be largely appreciated.
SELECT distinct on (bien.uid) bi
