Search Postgresql Archives

Re: Order of SUBSTR and UPPER in statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




"Hermann Muster" <Hermann.Muster@xxxxxx> wrote in message news:fov1p9$1l93$1@xxxxxxxxxxxxxxx
Hi,

I encountered something I can't really explain. I use the following statement in my application:

COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'')

This returns "ERROR:  syntax error at end of input"


However, using the following statement is fine:

COALESCE(SUBSTR(UPPER("X"."Firma"), 1, 7), '')


The fieldtype of "Firma" is character varying.

The only difference is the order of UPPER and SUBSTR. Is it possible that this changed during some PostgreSQL version update? By the way, right now I'm using 8.2.

Regards,
Hermann


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux