Thread: Pattern matching....

  Here's a question... in Perl, I could do a pattern match like this:

 =~ /$var[A-Z]/

  In PG, I can do something similar, matching a field name:

 ~* my_field

  But how do I add the "[A-Z]" to it?

steve

"Steve Wolfe" <steve@iboats.com> writes:
>   Here's a question... in Perl, I could do a pattern match like this:
>  =~ /$var[A-Z]/
>   In PG, I can do something similar, matching a field name:
>  ~* my_field
>   But how do I add the "[A-Z]" to it?

Uh, what's wrong with

    ~* (my_field || '[A-Z]')

Or am I missing the point?

            regards, tom lane

> Uh, what's wrong with
>
> ~* (my_field || '[A-Z]')
>
> Or am I missing the point?

 DOH!

  I tried that, but had left out the parenthesis.  Thanks, Tom, for waking
me back up.

steve