Re: textpos() function - Mailing list pgsql-general

From Hitesh Patel
Subject Re: textpos() function
Date
Msg-id 391908D3.2B10FCFC@presys.com
Whole thread Raw
In response to textpos() function  (Hitesh Patel <hitesh@presys.com>)
List pgsql-general
Tom Lane wrote:
>
\> Looks like it's called position() now --- that function has the same
OID
> (849) as 6.5's textpos(), and even more damningly points to a C function
> that's still called textpos():
>
> regression=# select oid,* from pg_proc where oid=849;
>  oid | proname  | proowner | prolang | proisinh | proistrusted | proiscachable |
>  pronargs | proretset | prorettype | proargtypes | probyte_pct | properbyte_cpu
> | propercall_cpu | prooutin_ratio | prosrc  | probin
> -----+----------+----------+---------+----------+--------------+---------------+
> ----------+-----------+------------+-------------+-------------+----------------
> +----------------+----------------+---------+--------
>  849 | position |      256 |      11 | f        | t            | t             |
>         2 | f         |         23 |       25 25 |         100 |              0
> |              1 |              0 | textpos | -
> (1 row)
>
> We've made a number of changes in 7.0 to bring function and type names
> into alignment with the SQL92 standard.  The incompatibilities I knew
> about were in date/time types and functions, but I guess this is another
> one ...
>
> If you really don't want to update your app's code just yet, you can
> install a pg_proc entry that defines textpos() with a CREATE FUNCTION
> command.  But the long-term answer is to fix your code to conform with
> the standard.
>
>                         regards, tom lane

I changed my code to use position() instead of textpos(), the only
problem is that I now get a parse error at the following line:

    i:= position(stringa, ',');

The exact error message is:

ERROR: parser: parse error at or near ","

Trying to run a query like, 'select position(email, ',') from table'
fails with the same parse error, however 'select strpos(email, ',') from
table' runs fine...

any hints?

--
|---------------------------------|----------------------------|
| Hitesh Patel                    |  Voice: (541) 759-3126     |
| Facilities Development Manager  |  Fax:   (541) 759-3214     |
| Preferred Systems               |  Email: hitesh@presys.com  |
|---------------------------------|----------------------------|

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.0 RPM?
Next
From: "Patrick FICHE"
Date:
Subject: Documentation about Postgres architecture