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

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 $BO

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

"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 co

Re: [SQL] Can COPY update or skip existing records?

On Tue, Sep 30, 2008 at 5:16 AM, Glenn Gillen <[EMAIL PROTECTED]> wrote: > Hey all, > > I've got a table with a unique constraint across a few fields which I > need to regularly import a batch of data into. Is there a way to do it > with COPY without getting conflicts on the unique contraint? I hav