Re: PL/TCL regex string matching - Mailing list pgsql-general

On Monday 20 November 2000 12:16, Marcin Mazurek wrote:
> Hi,
> I'm trying to write a TCL function which uses regex string matching.
>     spi_exec "SELECT count(s.id)  as res FROM services s
>                     WHERE
>                 s.name=''email account ([0-9+])MB''";
>
> I'd like to match any service with name starting "email account " and quota
> at the end.
> I was trying to use ([0-9+]), (1,2) and some others that I've found in TCL
> guides.
> Is it possible to use regex in PL/TCL and can You show me with the exmaple
> how?
>
> tia
> mazek
>
>
> Marcin Mazurek

These links might be useful:
http://www.postgresql.org/docs/aw_pgsql_book/node52.html
http://www.scriptics.com/man/tcl8.4/TclCmd/regexp.htm

Pg uses '~' as the regexp operator, so you can try that instead of the '='.
Check the first link to see the other pg regexp operators, there are four of
them.

--
-------- Robert B. Easter  reaster@comptechnews.com ---------
- CompTechNews Message Board   http://www.comptechnews.com/ -
- CompTechServ Tech Services   http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------