Re: seemingly slow for-loop in plpgsql - Mailing list pgsql-sql

From Claus Guttesen
Subject Re: seemingly slow for-loop in plpgsql
Date
Msg-id b41c75520809030020h5235e5c3y1991b21393ed5799@mail.gmail.com
Whole thread Raw
In response to Re: seemingly slow for-loop in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
> Why in the world are you using a for-loop for this at all?  It would be
> tremendously faster as a single SQL command:
>
> update duplicates set hashcode = rtrim(hashcode, E'\n') where length(hashcode) = 33;

Thank you. I was "caught" in the plpgsql-lane. This is of course much
simpler and much faster.

-- 
regards
Claus

When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.

Shakespeare


pgsql-sql by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: order of rows in update
Next
From: "Pavel Stehule"
Date:
Subject: Re: How do I get min and max from an array of floating point values