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.
> >
> > r
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 | prola
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 t
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