On Mon, Mar 27, 2017 at 9:16 AM, Adrian Klaver <[email protected]>
wrote:
> On 03/27/2017 09:03 AM, Brian Dunavant wrote:
>
>> That does not return the correct answer for the original poster's request.
>>
>> flpg=# select position('om' in reverse('Tomomasaaaaaaaaaaa'));
>> position
>> ----------
>> 15
>> (1 row)
>>
>
> It shows the position counting back from the end. If you want counting
> from the front:
>
> aklaver@test=> select (length('Tomomasaaaaaaaaaaa')+ 1) - position('om'
> in reverse('Tomomasaaaaaaaaaaa'));
> ?column?
> ----------
> 4
>
>
Choosing a word containing an embedded palindrome is not recommended when
dealing with "reverse string" examples...
David J.
