Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6])
	by hub.org (8.9.3/8.9.1) with ESMTP id KAA04096
	for <pgsql-sql@hub.org>; Tue, 27 Apr 1999 10:37:17 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA08410;
	Tue, 27 Apr 1999 10:36:43 -0400 (EDT)
To: Nuchanard Chiannilkulchai <nuch@valigene.com>
cc: pgsql-sql@hub.org
Subject: Re: [SQL] substring 
In-reply-to: Your message of Tue, 27 Apr 1999 10:15:35 +0200
	<37257226.17A344FA@valigene.com>
Date: Tue, 27 Apr 1999 10:36:43 -0400
Message-ID: <8408.925223803@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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