Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] substring - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] substring
Date
Msg-id 8408.925223803@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] substring  (Nuchanard Chiannilkulchai <nuch@valigene.com>)
List pgsql-sql
Tree view 
Nuchanard Chiannilkulchai <nuch@valigene.com> writes:
> The problem is : select  position ('_' in a ) from table_a  does not
> work.
>  ERROR:  No such function 'strpos' with the specified attributes

Hmm, I don't see that under either 6.4.2 or current sources.

What data type is your column a?  I tried text and char(n) and neither
one gave an error...
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Strange behavior
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Arrays and count()