Hi Andreas,
strange but I don't see html from my original email
received from the mailing list, hope this reply is ok:)
If I'm not wrong, the example you've provided is trying to
return matching rows from multiple patterns and texts as
inputs in the regex search.
The text in regular expression have to be just a single
string(with no white character) for my case. Matching should
then be done with patterns from each row, returning the row(s)
that contain matching regex pattern(s). Appreciate any advice.
Thanks.
Regards
pgdb
A. Kretschmer writes:
> am 13.04.2006, um 12:47:38 +0000 mailte pgdb
folgendes:
>>
>>
>>
>>
>>
Hi,
>>
>>
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
________________________________
Free POP3 Email from <a href="http://www.gawab.com"
target="_blank">www.gawab.com
Sign up NOW and get your account @gawab.com!!