Re: [SQL] textpos() in postgreSQL 7.0

2000-06-01 Thread Ross J. Reedstrom
Adam - Looks like it was renamed to strpos() in 7.0. A quick compatability hack to get up and running until you can rewrite the code would be to do something like: CREATE FUNCTION textpos (text,text) RETURNS int AS 'SELECT strpos($1,$2)' LANGUAGE 'SQL'; Now all your old code will work, just a

[SQL] textpos() in postgreSQL 7.0

2000-05-31 Thread Adam Walczykiewicz
Hi I notice that string function textpos() doesn't exist in postgreSQL 7.0. I have some plpgsql functions written for 6.5.2 that use textpos() and when I tried to use them in postgreSQL 7.0 I'v got error. Should I compile postgreSQL 7.0 with more options than -enable locale ?!!? ThanksĀ for