"Paul Punett" <[EMAIL PROTECTED]> writes: > Hi, > > I want to concatenate a it counter to a string in a loop in plpgsql. > DECLARE > counter integer := 1; > IdSet char : = 'UniqueId' > IdForEachRun varchar; > BEGIN > > IdForEachRun := IdSet || counter;(PROBLEM HERE)
IdForEachRun := IdSet || counter::text;
-Doug
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
