Re: [GENERAL] how to for loop with distinct values?

2012-05-22 Thread Dmitriy Igrishin
2012/5/22 Merlin Moncure mmonc...@gmail.com On Mon, May 21, 2012 at 3:39 PM, J.V. jvsr...@gmail.com wrote: I am banging my head over this. I want to select distinct values from a varchar column and iterate through the values. I want to select the distinct values from this column and

Re: [GENERAL] how to for loop with distinct values?

2012-05-22 Thread Merlin Moncure
On Tue, May 22, 2012 at 6:03 AM, Dmitriy Igrishin dmit...@gmail.com wrote: Nice color and font ;-) yup -- html formatted emails that I find displeasing get an automatic response in 'ms comic sans' :-D. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] how to for loop with distinct values?

2012-05-21 Thread J.V.
* I am banging my head over this. I want to select distinct values from a varchar column and iterate through the values. * *I want to select the distinct values from this column and loop through them (using as a variable) in a raise notice statement and also in an update statement. I have

Re: [GENERAL] how to for loop with distinct values?

2012-05-21 Thread Merlin Moncure
On Mon, May 21, 2012 at 3:39 PM, J.V. jvsr...@gmail.com wrote: I am banging my head over this. I want to select distinct values from a varchar column and iterate through the values. I want to select the distinct values from this column and loop through them (using as a variable) in a raise