Re: [SQL] SIMILAR TO

2010-10-16 Thread Rommel the iCeMAn
Thank you very much. I figured it was something simple but I am not proficient at regular expressions. Thanks again. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Saturday, October 16, 2010 10:30 AM To: Rommel the iCeMAn Cc: pgsql-sql@postgresql.org Subject: Re: [SQL

Re: [SQL] SIMILAR TO

2010-10-16 Thread Tom Lane
Rommel the iCeMAn writes: > I use the following code to detect alphanumeric strings: > IF _my_variable SIMILAR TO '^[a-zA-Z0-9]+$' THEN >         // do stuff here > END IF; > In pg8.4 this worked perfectly. I upgraded to pg9.0 and it no longer > works. From the release notes it appears that the