From: | Louis-David Mitterrand <cunctator(at)apartia(dot)ch> |
---|---|
To: | Pgsql-General(at)Postgresql(dot)org |
Subject: | edge of word atom in PG regex engine? |
Date: | 2000-10-04 10:45:01 |
Message-ID: | 20001004124501.A4965@styx.apartia.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
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 '4:5:67'::text ~ '\<4\>'::text as match;
match
-------
f
(1 row)
select '4:5:67'::text ~ '\b4\b'::text as match;
match
-------
f
(1 row)
Is there an equivalent under Postgres?
Thanks in advance,
--
Louis-David Mitterrand - ldm(at)apartia(dot)org - http://www.apartia.org
Disclaimer - These opiini^H^H damn! ^H^H ^Q ^[ .... :w :q :wq :wq! ^d X
exit X Q ^C ^? :quitbye CtrlAltDel ~~q :~q logout save/quit :!QUIT
^[zz ^[ZZZZZZ ^H man vi ^@ ^L ^[c ^# ^E ^X ^I ^T ? help helpquit ^D
mhelp ^C ^c help exit ?Quit ?q CtrlShftDel "Hey, what does this button d
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2000-10-04 11:18:06 | Re: Checking number of entries |
Previous Message | Tamsin | 2000-10-04 08:50:58 | pg_hba.conf advice |