[SQL] SQL function and composite types

2001-01-26 Thread Ron Sofrin
Hi all, having this simple table: create table foo (attribute text); and this simple function: create function f() returns foo as ' select ' 'test' '::text ' langauge 'sql' ; When I execute (though psql) select f(); I get the following result f 136411800 instead of

[SQL] Invoking sql functions through jdbc

2001-01-26 Thread Ron Sofrin
Hi all, I am trying to invoke a postgres sql function though JDBC using the CallableStatment object. I have build the driver with it's jdbc1.2 option. However, I am getting the following exception "Callable statments are not supported at this time" Does any one have an idea if there is a work ar