From: | Hermann Muster <Hermann(dot)Muster(at)gmx(dot)de> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Order of SUBSTR and UPPER in statement |
Date: | 2008-02-18 10:10:22 |
Message-ID: | 47B9598E.8090700@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Michael Fuhr schrieb:
> On Thu, Feb 14, 2008 at 04:48:33PM +0100, Hermann Muster wrote:
>
>> Michael Fuhr schrieb:
>>
>>>> COALESCE(UPPER(SUBSTR("X"."Firma",1,7)) =
>>>>
>>> I haven't examined the entire query but the above line appears to
>>> be the problem. Did you mean to write the following?
>>>
>>> COALESCE(UPPER(SUBSTR("X"."Firma",1,7)),'') =
>>>
>>>
>> Yes, that's what I wanted to write. However, it only works when I change
>> the order of UPPER and SUBSTR in the statement.
>>
>
> I still don't believe that order of UPPER and SUBSTR is relevant
> to the syntax error. Please post two complete queries, one with
> the order that works and one with the order that doesn't.
>
>
I'm terribly sorry, I found the mistake in my expression. There was one
bracket missing. That's why the one expression worked and the other
didn't. Sorry for any inconvenience.
Regards,
Hermann
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2008-02-18 10:11:19 | Re: msvcr80.dll and PostgreSQL 8.3 under Windows XP |
Previous Message | Hermann Muster | 2008-02-18 10:05:21 | Re: msvcr80.dll and PostgreSQL 8.3 under Windows XP |