| From: | "Paul Punett" <paul(dot)punett(at)shazamteam(dot)com> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | plpgsql |
| Date: | 2003-12-18 14:25:03 |
| Message-ID: | LEEEJFIHCGEJHMKLKOFBMEAKCAAA.paul.punett@shazamteam.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
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)
--Or IdForEachRun := IdSet + counter;(PROBLEM HERE)
While condition LOOP
Insert into Table values(IdForEachRun, ......)
counter := counter + 1;
IdForEachRun := IdSet || counter;(PROBLEM HERE)
--Or IdForEachRun := IdSet + counter;(PROBLEM HERE)
END LOOP
END
Language 'plpgsql'
Thanks in advance.
Paul Puneet
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Puneet Paul | 2003-12-18 14:29:30 | plpgsql Integer Concat To String |
| Previous Message | PostgreSQL Bugs List | 2003-12-18 13:07:15 | BUG #1014: postgres crash |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2003-12-18 14:46:02 | Re: Project status pages |
| Previous Message | ohp | 2003-12-18 14:07:16 | Re: TODO list |