Re: Extract last 4 characters from string? - Mailing list pgsql-general

Rodrigo De León wrote:
> On Dec 12, 2007 4:11 PM, D. Dante Lorenso <dante@lorenso.com> wrote:
>> Is there an easy (preferred) method that I'm missing?
> select substring('ABCDEFGHIJKLMNOP' from '....$');

Thanks!  Now, since I'd like to see a number in there, I'll do this:

   SELECT SUBSTRING('ABCDEFGHIJKLMNOP' FROM '.{4}$');

That does look a lot better than what I was cooking up ... appreciate
the help!

-- Dante