Re: [GENERAL] versioned pl/pgsql functions

2010-09-22 Thread Nagy Zoltan
ecific version of the function a la > git/svn...and then you could do diffs and what not so that you > wouldn't have to rely on text files which get lost because they were > on a tiny jump drive. > > Just my $1.70 > > > > Regards, > > Rhys >

Re: [GENERAL] optimizing import of large CSV file into partitioned table?

2010-03-28 Thread Nagy Zoltan
x27;ll have to update the index for every single entry. And the trigger > won't help either. Import into a single table and split it out into > further tables after if required. And finally the constraint should > probably be applied after too, so cull any violating rows after importing. > > Thom -- Nagy Zoltan (kirk) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] array/function question

2009-05-18 Thread Nagy Zoltan
hi, you should use something similar to 'merge sort' but only if your input is sorted (m_bx expects this) if your subjects (numbers) are not going beyond a certain limit eg(65535) take up an array and filter you can generate a poly for array B's roots, and calculate A's points -where it's 0,