Re: simple text parsing function

On Nov 21, 2008, at 3:35 PM, Kevin Duffy wrote:

> select getrfs_bbcode('BPZ8 CURNCY ', NULL, NULL);
> returns nothing. I need to receive 'BPZ8 CURNCY ' in
> this case.
>
>
> What am I missing?

I think it is because of your choice of types:

select rtrim('BPZ8 CURNCY ') like '%CURNCY'; --> true

select rtrim('BPZ8 CURNCY ')::char(25) like '%CURNCY'; --> false

Interestingly, it works if you make your comparison using ~ '.*CURNCY'

John DeSoi, Ph.D.