Return-Path: 
 <ibatis-user-java-return-2195-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 72631 invoked from network); 8 May 2005 06:45:21 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 8 May 2005 06:45:21 -0000
Received: (qmail 94021 invoked by uid 500); 8 May 2005 06:48:20 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 93804 invoked by uid 500); 8 May 2005 06:48:19 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 93787 invoked by uid 99); 8 May 2005 06:48:19 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of wpcfan@gmail.com designates
 64.233.184.206 as permitted sender)
Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.206)
  by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 07 May 2005 23:48:18 -0700
Received: by wproxy.gmail.com with SMTP id 69so1274496wri
        for <ibatis-user-java@incubator.apache.org>;
 Sat, 07 May 2005 23:45:18 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=KmPOZx3V4MXR/5+qOAtJQP4uNiIwhGqnG/Jj36Hrs4dQZ6srCIGiD9QGS58H/mblQNfp9GOkrcx+WIFw/tyAlgr8+Sm1HJR9n8sy65xvVhWveslgYHEtZFLKrAjCN6zz9ziqYYdYP/gIjaOo+wAeVBREizjnp4LT63gryqeGnY8=
Received: by 10.54.125.17 with SMTP id x17mr1780722wrc;
        Sat, 07 May 2005 23:45:18 -0700 (PDT)
Received: by 10.54.3.20 with HTTP; Sat, 7 May 2005 23:45:17 -0700 (PDT)
Message-ID: <299154da0505072345588647e3@mail.gmail.com>
Date: Sun, 8 May 2005 14:45:17 +0800
From: Peng Wang <wpcfan@gmail.com>
Reply-To: Peng Wang <wpcfan@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: PL/pgSQL function not working in <select> (more info)
In-Reply-To: <b6d6f73c4563b4c66a462778fb976a5f@irresponsiblecybernetics.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <a55653171decb382918ae12a93cc6676@irresponsiblecybernetics.com>
	 <16178eb1050507193911805340@mail.gmail.com>
	 <b6d6f73c4563b4c66a462778fb976a5f@irresponsiblecybernetics.com>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

try this
<select id=3D"getSilly" resultClass=3D"int" parameterClass=3D"string">
            select silly(#value#) from dual
 </select>

I think it can work.

On 5/8/05, Wolf <coyo@irresponsiblecybernetics.com> wrote:
> Hi Clinton,
>=20
>   Thanks for the response.  I have tried this through raw JDBC :
>           con =3D DriverManager.getConnection("jdbc:postgresql:wiki");
>           stat =3D con.createStatement();
>           stat.executeQuery("select silly('foo')");
>   and that works as expected.
>=20
>   I am using the same jdbc driver on both occasions.
>=20
>   I did try select('foo') from dual but I got  ERROR: relation "dual"
> does not exist. I think DUAL is an oracle only psuedo-table.
>=20
> -Wolf
>=20
> On May 7, 2005, at 7:39 PM, Clinton Begin wrote:
>=20
> >
> >  Try select silly(text) from dual.
> >
> >  Cheers,
> >  Clinton
> >
>=20
>