If I understand what you need,
I guess this clause does work.
WHERE string LIKE '%substring'
Best,
Oliveiros
- Original Message -
From: Kevin Duffy
To: pgsql-sql@postgresql.org
Sent: Friday, November 21, 2008 4:30 PM
Subject: [SQL] function - string ends with
Take a look at LIKE or ILIKE
kd
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Duffy
Sent: Friday, November 21, 2008 11:31 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] function - string ends with
Hello All:
Is anyone aware
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