Re: Query Help

For your very particular purpose, you may try to use

----------------
select * from table where substring(column, 0,1) between '0' and '9';
----------------

For a more general purpose, try the ~ operator.

\do will give you a list of available operators
You should maybe care about ~* operator also (case insensitive).

If you need to match one among many regular expressions, you can try to
store them in a little table, and then try:

----------------
select distinct table.* from table, regex_table where table.column ~
regex_table.regex;
----------------

DISTINCT is there to avoid that entries matching multiple regexps appear
multiple times.

No guarantees on performance.

HTH,

Antonio


Joe Koenig wrote:

>Thanks for the responses - I was able to patch something together from
>the responses. On to the next thing - I want to do a search based on a
>reg ex. Does PostgreSQL have something like MySQL's "RLIKE"? I want to
>pull all records in a category that start with a number 0-9. The best
>way I saw was to do a UNION with all the numbers, but I figured there
>was a better way. Thanks,
>
>Joe
>