Skip site navigation (1) Skip section navigation (2)

Re: function - string ends with

From: "Kevin Duffy" <KD(at)wrinvestments(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: function - string ends with
Date: 2008-11-21 16:47:48
Message-ID: DFC309C8A42633419600522FA8C4AE1A56110F@mail-01.wrcapital.corp (view raw or flat)
Thread:
Lists: pgsql-sql
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

 

In response to

pgsql-sql by date

Next:From: Oliveiros CristinaDate: 2008-11-21 16:53:46
Subject: Re: function - string ends with
Previous:From: Scott MarloweDate: 2008-11-21 16:46:19
Subject: Re: BULK COLLECT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group