From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | Adam Walczykiewicz <adam(dot)walczykiewicz(at)multiuser(dot)com(dot)pl> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: textpos() in postgreSQL 7.0 |
Date: | 2000-06-01 14:10:55 |
Message-ID: | 20000601091055.A20245@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Adam -
Looks like it was renamed to strpos() in 7.0. A quick compatability
hack to get up and running until you can rewrite the code would be to
do something like:
CREATE FUNCTION textpos (text,text) RETURNS int AS 'SELECT strpos($1,$2)'
LANGUAGE 'SQL';
Now all your old code will work, just a little slower.
Ross
On Thu, Jun 01, 2000 at 07:47:32AM +0200, Adam Walczykiewicz wrote:
> Hi
> I notice that string function textpos() doesn't exist in postgreSQL 7.0. I
> have some
> plpgsql functions written for 6.5.2 that use textpos() and when I tried to
> use them
> in postgreSQL 7.0 I'v got error.
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-06-01 18:10:03 | Re: SQL'92 web resources |
Previous Message | Jason.Weiss | 2000-06-01 13:57:22 | SQL Server and C++ Data Types |