"Steve Wolfe" <steve(at)iboats(dot)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