Re: Using regexp_matches in the WHERE clause

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Using regexp_matches in the WHERE clause
Date: 2012-11-27 12:30:59
Message-ID: k92bp7$pt1$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Pavel Stehule, 27.11.2012 13:26:
>> My question is: why I cannot use regexp_matches() in the WHERE clause, even
>> when the result is clearly an integer value?
>>
>
> use a ~ operator instead
>

So that means, regexp_matches cannot be used as an expression in the WHERE clause?

Regards
Thomas

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2012-11-27 12:35:48 Re: Using regexp_matches in the WHERE clause
Previous Message Pavel Stehule 2012-11-27 12:26:15 Re: Using regexp_matches in the WHERE clause