Re: [GENERAL] textpos() function

2000-05-10 Thread Hitesh Patel
Tom Lane wrote: \ Looks like it's called position() now --- that function has the same OID (849) as 6.5's textpos(), and even more damningly points to a C function that's still called textpos(): regression=# select oid,* from pg_proc where oid=849; oid | proname | proowner | prolang |

Re: [GENERAL] textpos() function

2000-05-10 Thread Mike Mascari
Hitesh Patel wrote: If you really don't want to update your app's code just yet, you can install a pg_proc entry that defines textpos() with a CREATE FUNCTION command. But the long-term answer is to fix your code to conform with the standard. regards, tom

[GENERAL] textpos() function

2000-05-09 Thread Hitesh Patel
I just upgraded to postgresql 7.0 and was restoring my data when I noticed I had a function defined that used the builtin textpos() function. This function was available in 6.5.3 but seems to have dissapeared in 7.0.. Is there any way to restore this function or has it been renamed to something

Re: [GENERAL] textpos() function

2000-05-09 Thread Tom Lane
Hitesh Patel [EMAIL PROTECTED] writes: I just upgraded to postgresql 7.0 and was restoring my data when I noticed I had a function defined that used the builtin textpos() function. This function was available in 6.5.3 but seems to have dissapeared in 7.0.. Is there any way to restore this