David Wilson escribió:
On Fri, Aug 1, 2008 at 12:30 PM, Linos <info@xxxxxxxx> wrote:
Well i would like to know if every can help with any other idea or any notes
on this problem? Other question i have it is how i could create a function
without be sure the number of columns to insert/update. Thanks in advance.
you could do:
begin;
create temporary table tmp (...);
[insert (or better yet, COPY) into tmp table]
[delete from real table where exists in temporary table];
insert into real_table select * from tmp;
drop table tmp;
commit;
Your client <--> server communication should be extremely small.
I think this is probably the better solution if i get the jdbc to use the copy command,
but i still dont know how to make a function with a variable column number, maybe i simply
can put all the columns and let the null columns insert/update with null.
Regards,
Miguel Angel.
