Postgres Pro
Downloads
Home   >   mailing lists

Re: function - string ends with - Mailing list pgsql-sql

From Oliveiros Cristina
Subject Re: function - string ends with
Date
Msg-id 021401c94bf9$b9fd87b0$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
In response to function - string ends with  ("Kevin Duffy" <KD@wrinvestments.com>)
List pgsql-sql
Tree view
If I understand what you need,
I guess this clause does work.
 
 
WHERE string LIKE '%substring'
 
Best,
Oliveiros
----- Original Message -----
Sent: Friday, November 21, 2008 4:30 PM
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

 

pgsql-sql by date:

Previous
From: "Kevin Duffy"
Date:
Subject: Re: function - string ends with
Next
From: "Kevin Duffy"
Date:
Subject: simple text parsing function