Re: simple text parsing function - Mailing list pgsql-sql

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.