> 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 muc
"Claus Guttesen" <[EMAIL PROTECTED]> writes:
> create or replace function update_hashcode() returns setof duplicates as
> $body$
> declare
> d duplicates%rowtype;
> h text;
> begin
> for d in select * from duplicates where length(hashcode) = 33 loop
> h := rtrim(d.hashcode, E'\n');
>
