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