How to get function return value

[Piotr Sobolewski]

Hi All!
It is my first post so if I am doing sth wrong please tell me.
I have a problem with value which is returned from postgresql function.
Probably java code is a problem but I will be very happy for yours help.

This is a sample function:
-- Function: test() -- DROP FUNCTION test(); CREATE OR REPLACE FUNCTION test() RETURNS integer AS $BODY$ DECLARE uid integer; BEGIN return -3; end; $BODY$ LANGUAGE plpgsql VOLATILE COST 100;

I expect that the function returns -3

When i use java code:

try {
            final PreparedStatement p = JDBCDAOFactory.getConnection().prepareStatement("SELECT test()");
            final ResultSet r = p.executeQuery();  
            if (r.next()) {
                int test = r.getInt(1);
                System.out.println(test);
            } else {
                System.out.println("Example");
            }
        } catch (SQLException e) {
            throw new DAOException(e);
        } catch (IOException e) {
            throw new DAOException(e);
        }

It always returns 0;
What is wrong?
I would be grateful for your help.

Best Regards!