Обсуждение: textsubstr() ...? for postgres 7 beta5

Поиск
Список
Период
Сортировка

textsubstr() ...? for postgres 7 beta5

От
nathan@khmere.com
Дата:
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


Re: [SQL] textsubstr() ...? for postgres 7 beta5

От
Tom Lane
Дата:
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

Re: Re: [SQL] textsubstr() ...? for postgres 7 beta5

От
nathan@khmere.com
Дата:
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


Re: [HACKERS] Re: Re: [SQL] textsubstr() ...? for postgres 7 beta5

От
Tom Lane
Дата:
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

Re: [HACKERS] Re: Re: [SQL] textsubstr() ...? for postgres 7 beta5

От
Lincoln Yeoh
Дата:
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
>
>