On Tue, Jun 19, 2007 at 07:36:02PM -0400, Tom Lane wrote: > "Rhys Stewart" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
