Re: reg expressions

--- "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..... carlos == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net