Is there a RIGHT function in postgres?

Databases
1

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?

2

substring(daColumn from char_length(daColumn)-4)

or

substring(daColumn from ‘…$’)

3

thanks r937

4