On Mon, Jul 27, 2009 at 8:48 AM, Jamie Lawrence-Jenner<jamie.jen...@autovhc.co.uk> wrote: > Hi There > > Our update statements are as follows > > Update table set col1=x,col2=y where pkid=1; > Update table set col1=x,col2=y where pkid=2; > Update table set col1=x,col2=y where pkid=3; > > Very simple and straight forward. Sometimes there could be as many as 50 > update statements to process.
Might as well fire them each as separate statements inside one transaction, since pkid is unique and non-repeated in the updates. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
