| From: | "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
|---|---|
| To: | "Kevin Duffy" <KD(at)wrinvestments(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: function - string ends with |
| Date: | 2008-11-21 16:53:46 |
| Message-ID: | 021401c94bf9$b9fd87b0$ec5a3d0a@marktestcr.marktest.pt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Duffy | 2008-11-21 20:35:44 | simple text parsing function |
| Previous Message | Kevin Duffy | 2008-11-21 16:47:48 | Re: function - string ends with |