Re: 7.4.7: due to optimizing of my query logik breaks

On Wed, Sep 14, 2005 at 10:03:37AM -0400, Tom Lane wrote:

> http://www.postgresql.org/docs/7.4/static/sql-expressions.html#SYNTAX-EXPRESS-EVAL

thanks for this url - i can use the described CASE syntax for my case. i
just have to assure using the regexp, that the later cast to int4 will
work. i was not aware of the possibility to use the CASE also "behind"
the WHERE and not only "before".

--
cu