Postgres Pro
Downloads
Home   >   mailing lists

Array comparison - Mailing list pgsql-performance

From ramasubramanian
Subject Array comparison
Date
Msg-id 10E4D065260941509531A32BDC0AB647@ramasubramanian
Whole thread Raw
In response to Joining on text field VS int  (Radhika S <rs88820@gmail.com>)
Responses Re: Array comparison
List pgsql-performance
Tree view
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
 

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Air-traffic benchmark
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: Massive table (500M rows) update nightmare