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.
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 |
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 |