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.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql