On Tue, Jun 19, 2007 at 07:36:02PM -0400, Tom Lane wrote: > "Rhys Stewart" <rhys.stewart@xxxxxxxxx> writes: > > Is regex searching not functioning (as i expect it to?) > > ~ expects the pattern on the right, not the left. So it's taking your > array entries as patterns, which don't match the data 'Trans'. > > Since there's no "(array) ANY op scalar" syntax, Why isn't there? Is it forbidden by the SQL standard? Cheers, D -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
