Louis-David Mitterrand writes:
> I am trying to match the following:
>
> select '4:5:67'::text ~ '4'::text as match;
> match
> -------
> t
> (1 row)
>
> but I would like to avoid '44:5:67' matching '4' so I tried including
> "word edge" regexp atoms (\b in perl, \<\> in grep and vi, etc..) but
> they don't seem to be supported in Postgres:
select '44:5:67'::text ~ '[[:<:]]4[[:>:]]';
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/