[GENERAL] textsubstr() ...? for postgres 7 beta5

2000-04-30 Thread nathan
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

[GENERAL] New eMail address

2000-04-30 Thread Jan Wieck
Hi folks, would anyone please update his aliases? My new email address is [EMAIL PROTECTED] I'll be able to read mail addressed to [EMAIL PROTECTED] until end of May. Mail reaching that address after May will probably get lost. Jan -- #

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

2000-04-30 Thread Tom Lane
[EMAIL PROTECTED] 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?

[GENERAL] implementing refcounts across tables.

2000-04-30 Thread Alfred Perlstein
Think of this problem as handling unix style filesystem hardlinks. Consider two tables: create table link ( data_id int4, link_date timestamp ); create table data ( date_id int4 PRIMARY KEY, data_txt text ); We may have multiple "link" rows pointing at the same data. What I would like

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

2000-04-30 Thread nathan
Tom Lane wrote: > [EMAIL PROTECTED] 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

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

2000-04-30 Thread Tom Lane
[EMAIL PROTECTED] 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