No error when run with most recent SQLite. replace() may not have existed in 3.3.7.
--- Jim Dodgen <[EMAIL PROTECTED]> wrote: > I get an error in version 3.3.7 when using the replace function as defined > here: > > http://sqlite.org/lang_expr.html > > "replace(X,Y,Z) Return a string formed by substituting string Z for > every occurrance of string Y in string X. The BINARY collating sequence is > used > for comparison" > > --- test case --- > > create temp table temp_x (a,b); > insert into temp_x values ("foo/bar",1); > select a,b from temp_x where replace(a,"/","-") <> "foo-bar"; > > --- error message --- > > error: 1 - no such function: replace(1) at dbdimp.c line 271 select a,b from > temp_x where replace(a,"/","-") <> "foo-bar" ____________________________________________________________________________________Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
