Em 20/06/2012 15:03, John R Pierce escreveu:
On 06/20/12 10:37 AM, Edson Richter wrote:select * from tb1 where nome like 'CARLOS%' or reverse(nome) like reverse('%CARLOS') Should return same results as select * from tb1 where nome like '%CARLOS%'no, that won't match 'abcCARLOSxyx'
Perfect. I did not realized this case. Thanks, Edson. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
