Re: Pattern matching.... - Mailing list pgsql-general

From Tom Lane
Subject Re: Pattern matching....
Date
Msg-id 8053.1013209600@sss.pgh.pa.us
Whole thread Raw
In response to Pattern matching....  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Edwin Grubbs
Date:
Subject: Re: foreign keys and transactions
Next
From: "Steve Wolfe"
Date:
Subject: Re: Pattern matching....