PL/pgSQL question - record or %ROWTYPE?
От
Egyud Csaba
Тема
PL/pgSQL question - record or %ROWTYPE?
Дата
Msg-id
000301c31406$9035a560$800a0a0a@xxx
Список
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.
В списке pgsql-general по дате отправления