Postgres Pro
Downloads
Home   >   mailing lists

Re: Using regexp_matches in the WHERE clause - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: Using regexp_matches in the WHERE clause
Date
Msg-id k92bp7$pt1$1@ger.gmane.org
Whole thread Raw
In response to Re: Using regexp_matches in the WHERE clause  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Using regexp_matches in the WHERE clause  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Using regexp_matches in the WHERE clause
Next
From: Pavel Stehule
Date:
Subject: Re: Using regexp_matches in the WHERE clause