Re: [SQL] function - string ends with

[Oliveiros Cristina]

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


  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