Re: [GENERAL] Checking for a number

[Osvaldo Rosario Kussama]

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster