Re: Pattern matching....

"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