Re: regexp searching in arrays not working?

On Tue, Jun 19, 2007 at 07:36:02PM -0400, Tom Lane wrote:
> "Rhys Stewart" <rhys.stewart@gmail.com> 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@fetter.org> 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