| From: | "Egyud Csaba" <csegyud(at)freemail(dot)hu> |
|---|---|
| To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | PL/pgSQL question - record or %ROWTYPE? |
| Date: | 2003-05-06 19:34:29 |
| Message-ID: | 000301c31406$9035a560$800a0a0a@xxx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerhard Hintermayer | 2003-05-06 19:43:24 | Re: Backend memory leakage when inserting |
| Previous Message | Peter Childs | 2003-05-06 19:26:36 | Re: What is the best practise for "autonumbering"..? |