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