On Fri, Jan 8, 2010 at 11:06 AM, Rui Carvalho wrote:
> 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 also have the option of expand
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
Hi all,
I want to compare the two arrys in sql, The below example is wrong.
But i want to know how to do that in postgres 8.2.5
SELECT 'x' WHERE string_to_array('the,quick,ram,fox', ',') any
(string_to_array('the,quick,lazy ,fox', ','))
Regards,
Ram
