>>
>>
like to know how, if possible, for patterns
>> as attribute in a table to be used in a regex
search with a
>> fixed string. The query should therefore return
the rows that
>> have matching patterns with the single
text.
>
> It's hard to read such text, please use plain ASCII
insteed HTML.
>
> Perhaps you are looking for something like this:
>
> test=# select * from search;
> text
> ----------------
> this is a test
> (1 row)
>
> test=# select * from pattern;
> text
> ---------
> ^this.*
> ^foo
> (2 rows)
>
> test=# select pattern.text, search.text from pattern,
search where search.text ~ pattern.text;
> text | text
> ---------+----------------
> ^this.* | this is a test
> (1 row)
>
>
>
> HTH, Andreas
> --
> Andreas Kretschmer (Kontakt: siehe Header)
> Heynitz: 035242/47215, D1: 0160/7141639
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
> === Schollglas Unternehmensgruppe ===
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq