Re: problem with RECORD in a stored procedure

From: daq <daq(at)ugyvitelszolgaltato(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: problem with RECORD in a stored procedure
Date: 2002-03-08 17:53:15
Message-ID: 1746949476.20020308185315@ugyvitelszolgaltato.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


B is record type and you can't insert a record into a field.
You must rewrite your code like this:

FOR b IN SELECT MIN(total) as mintotal from results LOOP
INSERT INTO orla(total) VALUES(b.mintotal);
END LOOP;

DAQ

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message knut.suebert 2002-03-08 18:38:11 Support for "nested sets" and PHP (Re: Recursive select)
Previous Message Stephan Szabo 2002-03-08 16:16:10 Re: problem with RECORD in a stored procedure