Re: Checking for a number - Mailing list pgsql-general

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