Re: textpos() in postgreSQL 7.0

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Adam Walczykiewicz <adam(dot)walczykiewicz(at)multiuser(dot)com(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: textpos() in postgreSQL 7.0
Date: 2000-06-02 06:10:41
Message-ID: 39374FE1.5B197DF@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I notice that string function textpos() doesn't exist in postgreSQL
> 7.0.

Sorry about that. We (well, I) remapped it into the SQL92-standard
function "position()". I believe it is mentioned in the release notes,
but maybe not.

One of the joys of a full-up, major release. Hope it doesn't cause too
much trouble for you. btw, textpos() is still a routine in the database
backend, so you could pretty easily create a new catalog entry for it if
it is not feasible to change your app.

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wim Ceulemans 2000-06-02 09:06:04 Re: query optimiser changes 6.5->7.0
Previous Message Tom Lane 2000-06-02 05:43:55 Re: Vacuum Question