Return-Path: 
 <ibatis-user-java-return-2190-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 44939 invoked from network); 8 May 2005 03:27:38 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 8 May 2005 03:27:38 -0000
Received: (qmail 83690 invoked by uid 500); 8 May 2005 03:30:36 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 83634 invoked by uid 500); 8 May 2005 03:30:34 -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 83618 invoked by uid 99); 8 May 2005 03:30:34 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=FORGED_RCVD_HELO
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from dsl017-119-094.sfo1.dsl.speakeasy.net (HELO
 puppy.irresponsiblecybernetics.com) (69.17.119.94)
  by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 07 May 2005 20:30:34 -0700
Received: from [192.168.111.101] (dsl017-119-094.sfo1.dsl.speakeasy.net
 [69.17.119.94])
	by puppy.irresponsiblecybernetics.com (Postfix) with ESMTP id 5BB2A60EC
	for <ibatis-user-java@incubator.apache.org>;
 Sat,  7 May 2005 21:19:15 -0700 (PDT)
Mime-Version: 1.0 (Apple Message framework v622)
In-Reply-To: <16178eb1050507193911805340@mail.gmail.com>
References: <a55653171decb382918ae12a93cc6676@irresponsiblecybernetics.com>
 <16178eb1050507193911805340@mail.gmail.com>
Content-Type: multipart/alternative; boundary=Apple-Mail-1--223303081
Message-Id: <b6d6f73c4563b4c66a462778fb976a5f@irresponsiblecybernetics.com>
From: Wolf <coyo@irresponsiblecybernetics.com>
Subject: Re: PL/pgSQL function not working in <select> (more info)
Date: Sat, 7 May 2005 20:27:30 -0700
To: ibatis-user-java@incubator.apache.org
X-Mailer: Apple Mail (2.622)
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


--Apple-Mail-1--223303081
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed

Hi Clinton,

   Thanks for the response.  I have tried this through raw JDBC :
           con = DriverManager.getConnection("jdbc:postgresql:wiki");
           stat = con.createStatement();
           stat.executeQuery("select silly('foo')");
   and that works as expected.

   I am using the same jdbc driver on both occasions.

   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.

-Wolf


On May 7, 2005, at 7:39 PM, Clinton Begin wrote:

>
>  Try select silly(text) from dual.
>
>  Cheers,
>  Clinton
>

--Apple-Mail-1--223303081
Content-Transfer-Encoding: 7bit
Content-Type: text/enriched;
	charset=US-ASCII

Hi Clinton,


  Thanks for the response.  I have tried this through raw JDBC : 

          con = DriverManager.getConnection("jdbc:postgresql:wiki");

          stat = con.createStatement();

          stat.executeQuery("select silly('foo')");

  and that works as expected.


  I am using the same jdbc driver on both occasions.

 

  I did try <italic>select('foo') from dual </italic>but I got 
<bold>ERROR: relation "dual" does not exist.</bold> I think DUAL is an
oracle only psuedo-table.


-Wolf



On May 7, 2005, at 7:39 PM, Clinton Begin wrote:


<excerpt>

 Try select silly(text) from dual.


 Cheers,

 Clinton


</excerpt>
--Apple-Mail-1--223303081--