textsubstr() ...? for postgres 7 beta5

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

--------+-------------+---------------+--------------------------------------