am 13.04.2006, um 12:47:38 +0000 mailte pgdb folgendes:
>
> <HTML><DIV class=bgcolor STYLE="background-color: ;"><DIV>
> <DIV>
> <DIV>
> <DIV>Hi,</DIV>
> <DIV> </DIV>
> <DIV>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.</DIV>
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 ===