Re: Checking for a number

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Osvaldo Rosario Kussama <osvaldo_kussama(at)yahoo(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Checking for a number
Date: 2007-06-27 21:17:48
Message-ID: 252396.18858.qm@web31808.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


--- Osvaldo Rosario Kussama <osvaldo_kussama(at)yahoo(dot)com(dot)br> wrote:
> Try:
> SELECT your_field ~ '.*[[:digit:]]{2}$';

This could be simplified a little. :o)

WHERE your_field ~ '\\d{2}$';

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce McAlister 2007-06-27 21:18:37 Re: AutoVacuum Behaviour Question
Previous Message Osvaldo Rosario Kussama 2007-06-27 21:14:59 Re: Checking for a number