Hi,
I ran into a problem trying to read out data from a table by means of a
PL/pgSQL expression (for ... in execute ...).
First I used a "tablename%ROWTYPE" type variable as a placeholder for the
record data. It failed when I executed the expression. The problem was
around a value in a "double precision" type field (pg_atoi: error in
"1390.5525": can't parse: ".5525" ).
After changing the record variable type to the general "record" type the
error disappeared.
What could be the reason?
I would think that the "%ROWTYPE" type has exactly the same structure as the
addressed table. Maybe I make a mistake.
thanks,
-- Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.435 / Virus Database: 244 - Release Date: 2002.12.30.