Re: reg expressions
From: Carlos Benjamin <benj@firstlinux.net>
>
>--- "Obnoxio The Clown" <obnoxio@hotmail.com>
> > wrote:
> >From: "Martin A. Marques" <martin@math.unl.edu.ar>
> >>
> >>How does informix treat regular expresions in a SELECT query. Something
> >>like this:
> >>
> >>SELECT * FROM friend WHERE firstname `^S`> >>
> >>just like PostgreSQL does???
> >
> >Gee, I don't know. http://www.informix.com/answers You mean UNIX RE's?
> >http://www.informix.com/answers SQL has it's own RE syntax.
> >http://www.informix.com/answers
> >
> >http://www.informix.com/answers I kind of hope
> >http://www.informix.com/answers that if I http://www.informix.com/answers
> >drop enough http://www.informix.com/answers hints some more
> >http://www.informix.com/answers initial research
> >http://www.informix.com/answers might take
>http://www.informix.com/answers
> >place before http://www.informix.com/answers questions
> >http://www.informix.com/answers get asked http://www.informix.com/answers
>on
> >this http://www.informix.com/answers list...?
> >
> >Have you even tried the query? What happened? Let me guess: you got error
> >-201: A syntax error has occurred? I guess that might just mean that the> >syntax you suggest is not supported. Perhaps you might try:
> >
> >SELECT * FROM friend WHERE firstname NOT MATCHES S*'; -- back quotes are
>not> >valid
> >
> >or
> >
> >SELECT * FROM friend WHERE firstname NOT LIKE 'S%'; -- back quotes are
>not> >valid
> >
> >Like it says in the manual. Which can be found at
> >http://www.informix.com/answers And just to narrow it down, there's one
> >called, believe it or not: Guide to Syntax.
> >
>
>Suddenly I feel the need to go buy a big tub of popcorn and a huge fountain
>drink.....
Aaaaagh! Wrong response! Wrong response! :-(((
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com