Re: Checking for a number

[Osvaldo Rosario Kussama <osvaldo_kussama@xxxxxxxxxxxx>]

Warren escreveu:
> I need to check if the last two characters of a field are a number. I am 
> trying something like this but it does not want to work.
>
> substring(TRIM(field8) from '..$') SIMILAR TO '\d\d'
>
> How should I do this?

Try:
SELECT your_field ~ '.*[[:digit:]]{2}$';

Osvaldo