Hi

suppose we have the following query:
select ....from ...where...and x *=3;

"x" is an integer array,here we want to check whether
"x" contains 3 or not,this is the same as one of
postgre documentaion example,however it doesnt
work.(why???)

should I set any option? any idea?

-thnx



__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

On Thu, 2004-07-08 at 06:20, gavaneh wrote:
9.17.3. ANY/SOME (array)
expression operator ANY (array expression)
expression operator SOME (array expression)

The right-hand side is a parenthesized expression, which must
yield an array value. The left-hand expression is evaluated and
compared to each element of the array using the given operator,
which must yield a Boolean result. The result of ANY is "true"
if any true result is obtained. The result is "false" if no true
result is found (including the special case where the array has
zero elements).

SOME is a synonym for ANY

So in your case:
SELECT ... FROM .. WHERE ... 3 = ANY (x);


Oliver Elphick


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

gavaneh <gavaneh (AT) yahoo (DOT) com> writes:
Probably because you didn't install the contrib module that supports
the *= operator.

Note that as of 7.4 there is a more standard way to do this.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster