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

From: Christoph Frick <frick(at)sc-networks(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: 7.4.7: due to optimizing of my query logik breaks
Date: 2005-09-14 14:11:48
Message-ID: 20050914141148.GF22404@byleth.sc-networks.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-09-14 19:06:11 PGSQL 8.03 Windows Install Instruction Comments / Questions
Previous Message Tom Lane 2005-09-14 14:03:37 Re: 7.4.7: due to optimizing of my query logik breaks