Title: RE: [SQL] Regex
Thanks Tom,
I attacked the issue another way which appears to work...
I used :
explain select * from nodes left join node_names on node_names.node_id = nodes.node_id
which returned :
query
QUERY PLAN
Theo Galanakis <[EMAIL PROTECTED]> writes:
> Basically the regex should return TABLEA, TABLEB from:
> Select *
> from TABLEA
> Inner jon TABLEB on tableb.columna = tablea.columna
You realize of course that this problem is mathematically impossible?
Regexes are less powerful than context-free gra
Title: Regex
I know this is not a regex forum, however I had great assistance last time and thought I would ask, since the regex is looking through an SQL statement.
I was trying to parse a SQL statement and get all the tables used. I'm actually doing this in Cold Fusion.
I have gone as far
Ð ÐÑÐ, 25.07.2004, Ð 21:41, Tom Lane ÐÐÑÐÑ:
> Markus Bertheau <[EMAIL PROTECTED]> writes:
> > pg's regex engine does have one
> > shortcoming though: it doesn't know UTF-8.
>
> Sure it does. We borrowed it from Tcl, remember?
>
> The "character class" stuff is not locale-aware at the moment,
> w
Markus Bertheau <[EMAIL PROTECTED]> writes:
> pg's regex engine does have one
> shortcoming though: it doesn't know UTF-8.
Sure it does. We borrowed it from Tcl, remember?
The "character class" stuff is not locale-aware at the moment,
which is something that ought to get fixed eventually, but cl
Ð ÐÑÐ, 25.07.2004, Ð 19:34, Tom Lane ÐÐÑÐÑ:
> Markus Bertheau <[EMAIL PROTECTED]> writes:
> > Ð ÐÑÐ, 25.07.2004, Ð 16:40, Jean-Luc Lachance ÐÐÑÐÑ:
> >> Better yet:
> >>
> >> SELECT * FROM table WHERE phrase ~ '^[0-9]';
>
> > Not so sure if that's better - the regex engines aren't the fastest.
>
