Re: PL/pgSQL function not working in <select> (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 <coyo@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> 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