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
