Hi,
I'm working through Bruce Momjian's online tutorial on PostreSQL, and am
now trying to get my head around regular expressions. The tutorial says
that ~ '^X' where 'X' is a character, will find table entries beginning
with that character.
When I try it ...
SELECT * FROM testdb ~'^d' ;
ERROR: parser: parse error at or near "~"
I get this, irrespective of the regular expression that I use. It _is_ a
tilde, isn't it ? Or is my eyesight going ..? :-(
Thanks.
D.
--
Desmond Coughlan |'Io non mori, e non rimasi vivo'
desmond(at)zeouane(dot)org
http://www.zeouane.org