[SQL] Accessing elements of bytea[] always returns NULL

2008-10-01 Thread Sestak, John S
Hi all, I'm trying to pass in a bytea array (i.e. bytea[]) into my stored procedure but when I try to access the elements in the array using an array index it always returns NULL. In other words, if I do the following: CREATE OR REPLACE FUNCTION some_function( _test BYTEA[] ) RETURNS BIGINT AS

Re: [SQL] Accessing elements of bytea[] always returns NULL

2008-10-01 Thread Tom Lane
Sestak, John S [EMAIL PROTECTED] writes: I'm trying to pass in a bytea array (i.e. bytea[]) into my stored procedure but when I try to access the elements in the array using an array index it always returns NULL. Works fine from SQL, so I suppose there's something wrong with your JDBC code.