Is there a RIGHT function in postgres?

I’m using postgres 8.

I’m trying to create a query for pulling the last 4 characters of a field. But, I don’t think there’s a RIGHT function in postgres. The entries in the field are all different lengths. Is there someway to do this?

substring(daColumn from char_length(daColumn)-4)


substring(daColumn from ‘…$’)

thanks r937