Re: [SQL] how to update 400 000 register not at the same time?

2008-12-02 Thread Shane Ambler
John Dizaro wrote: I Have um very big table with primary key and all i nead. When i update same register from this table it comes sj=low. Can i Update all my 400 000 register not at the same time? By steps? Thanks Yes - provided you can come up with a definite way to separate your records i

Re: [SQL] JOIN results of refcursor functions

2008-12-02 Thread Milan Oparnica
Milan Oparnica wrote: Then I've tried: CREATE FUNCTION foo(insklid int, out sklid int, out elid INT) RETURNS SETOF record AS $$ BEGIN RETURN QUERY SELECT sklid,elid FROM skladkol; RETURN; END; $$ LANGUAGE plpgsql; but it returns 5498 rows (which is exact number of rows in that table) bu