varchar for loops possible? - Mailing list pgsql-general

From J.V.
Subject varchar for loops possible?
Date
Msg-id 4FB6B174.7090206@gmail.com
Whole thread Raw
Responses Re: varchar for loops possible?
Re: varchar for loops possible?
List pgsql-general
I have a table with a varchar column.

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 not been able to do this trying over 100 things in the last two
hours.  I could not find an example on google.

     for tmp_var in select distinct(value) from mytable where
value2='literal'
     loop
         raise notice 'I want to print a message here - the tmp_var is
[' || tmp_var || ']';
         update table set varcharid = ''' || tmp_var || '''
     end loop;

tmp_var has to be in  ' ' ticks or will not work.  it is failing on the
first FOR statment stating:  "invalid input syntax for integer:
"some_distinct_value".

How do I select varchar distinct values and iterate using variables in a
raise notice statement and inside another update statement?

this seems simple to do , but have not found a way.

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Fetching multiple rows in single round trip
Next
From: Tom Lane
Date:
Subject: Re: varchar for loops possible?