Re: function - string ends with

Take a look at LIKE or ILIKE

kd

________________________________

From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Kevin Duffy
Sent: Friday, November 21, 2008 11:31 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] function - string ends with

Hello All:

Is anyone aware of a function in PgSQL that will check if a string ends
with a specific string?

I.e. rposition(substring in string ) returns int

Starts searching right to left within string

Thanks for your attention to this matter.

Kevin Duffy