functions in PostgreSQL are called via a select statement. Issue "select your_custom_function()" in a Statement or PreparedStatement. Then get the result like any other select statement via the ResultSet.
thanks, --Barry Oleg Lebedev wrote: > Hi, > I created a PL/pgSQL function, but can not call it from my Java program. > > I tried using CallableStatement, but it gave me an exception: > Callable Statements are not supported at this time. > So, how should I execute a stored procedure via JDBC? > Thanks, > > Oleg > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
