Re: BUG #8335: trim() un-document behaviour

From: Romain Billon-Grand <romainbillongrand(at)yahoo(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8335: trim() un-document behaviour
Date: 2013-08-09 10:40:29
Message-ID: 1376044829269-5766930.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Running postgres 9.1.4 using pgAdmin3 on a macbook air intel OS 10.6

I just had this bug, using comma:

SELECT trim(trailing texte_natif , 'DATEDENAISSANCE' ) FROM CROP

returned the whole field, including the string 'DATEDENAISSANCE', but except
the very first character, the column being called rtrim.

Tryed to chang it to
SELECT trim(trailing texte_natif from 'DATEDENAISSANCE' ) FROM CROP

returned nothing ( as a dummy in postgres I can't say if it was null fields
or empty string...)

CROP.texte_natif is a quite long texte field,in which the STRING
'DATEDENAISSANCE can be present 0 to 3 times, and never before 20th
character

bests
Romain

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8335-trim-un-document-behaviour-tp5765221p5766930.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Luca Ferrari 2013-08-09 11:09:40 Re: Recovery.conf and PITR
Previous Message wd 2013-08-09 10:40:04 Re: Recovery.conf and PITR

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2013-08-09 12:44:05 Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
Previous Message Bisen Vikrantsingh Mohansingh MT2012036 2013-08-09 10:03:37 Re: Proposal for XML Schema Validation