Re: PL/pgSQL function not working in (more info)

put




hi eric,

probably out of date. just in case:
try this in your config

  <transactionManager type="JDBC" commitRequired="true">

mischa


Peng Wang wrote:
> try this
> <select id="getSilly" resultClass="int" parameterClass="string">
>             select silly(#value#) from dual
>  </select>
> 
> I think it can work.
> 
> On 5/8/05, Wolf <co...@irresponsiblecybernetics.com> wrote:
> 


>>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
>>>
>>
>>
> 

---