Re: rtrim giving weird result - Mailing list pgsql-hackers

From G. Anthony Reina
Subject Re: rtrim giving weird result
Date
Msg-id 3AB0FD0C.AB9B72CC@nsi.edu
Whole thread Raw
In response to rtrim giving weird result  ("G. Anthony Reina" <reina@nsi.edu>)
Responses Re: rtrim giving weird result  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-hackers
Ken Hirsch wrote:

> So rtrim("center_out_opto", "_opto") returns
>     "center_ou"
> because "u" is not in the set {o, p, t, _} but all the characters after it
> are.
> rtrim("center_out_opto", "pot_") will produce the same thing.
>

That seems like an odd definition (although as Tom points out, it is
consistent with Oracle).

Is there a way to just remove the "_opto" from the end of the string?

-Tony




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sheduling in SQL
Next
From: Tom Lane
Date:
Subject: Allowing WAL fsync to be done via O_SYNC