Thread: textsubstr() ...? for postgres 7 beta5
I have installed the beta 7 for postgres but... it seems to be missing some text functions ? l like the textsubstr ? Is this beacuse it is a "beta" and the final release will include these or are they forever droped ? Please let me know thank you nathan
nathan@khmere.com writes:
> I have installed the beta 7 for postgres but... it seems to be missing
> some text functions ? l
> like the textsubstr ?
Huh? There is no function named textsubstr() in 6.5.*, either. Perhaps
you had some locally user-defined functions you forgot to reinstall?
regards, tom lane
Tom Lane wrote: > nathan@khmere.com writes: > > I have installed the beta 7 for postgres but... it seems to be missing > > some text functions ? l > > > like the textsubstr ? > > Huh? There is no function named textsubstr() in 6.5.*, either. Perhaps > you had some locally user-defined functions you forgot to reinstall? > > regards, tom lane Opps... Ok, well I made a mistake.... it is not textsubstr() but this : (found in 6.5.2 redhat ) result |function |arguments |description --------+-------------+---------------+--------------------------------------- text |text_substr |text int4 int4 |return portion of string Is this in 7.0 ? (PS this is not user defined, well at least I did not make it ...? ) thank you nathan
nathan@khmere.com writes: > it is not textsubstr() but this : (found in 6.5.2 redhat ) > result |function |arguments |description > --------+-------------+---------------+-------------------------------------- > text |text_substr |text int4 int4 |return portion of string > Is this in 7.0 ? Looks like it's called just plain "substr" now. See http://www.postgresql.org/docs/postgres/functions.htm regards, tom lane
Is there a copy of the old 6.5.x docs lying around somewhere? We'll probably switch to 7.0 eventually but in the meantime it'll be good to be able to access the old docs for 6.5.x Cheerio, Link. At 08:30 PM 30-04-2000 -0400, Tom Lane wrote: >nathan@khmere.com writes: >> it is not textsubstr() but this : (found in 6.5.2 redhat ) > >> result |function |arguments |description >> --------+-------------+---------------+-------------------------------------- >> text |text_substr |text int4 int4 |return portion of string > >> Is this in 7.0 ? > >Looks like it's called just plain "substr" now. See >http://www.postgresql.org/docs/postgres/functions.htm > > regards, tom lane > >