Home > mailing lists

Order of SUBSTR and UPPER in statement - Mailing list pgsql-general

From	Hermann Muster
Subject	Order of SUBSTR and UPPER in statement
Date	February 13, 2008 14:38:27
Msg-id	fov1p9$1l93$1@news.hub.org Whole thread Raw
Responses	Re: Order of SUBSTR and UPPER in statement Re: Order of SUBSTR and UPPER in statement
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Peter Wilson
Date: 13 February 2008, 14:22:39
Subject: Re: Storing images as BYTEA or large objects

From: Ken Johanson
Date: 13 February 2008, 15:08:02
Subject: Re: SELECT CAST(123 AS char) -> 1

Order of SUBSTR and UPPER in statement - Mailing list pgsql-general

Previous

Next