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 majordomo@postgresql.org
>
>