On Fri, Apr 06, 2007 at 03:52:17AM +0200, Rikard Pavelic wrote:
When I select from this function I get an error
ERROR: record red has no field id
[...]
create function select_ex1(out id int, out name1 varchar, out value1
int) returns setof record as
$$
declare red record;
begin
for
Hi!
Can someone help me with this problem.
When I select from this function I get an error
ERROR: record red has no field id
SQL state: 42703
Context: PL/pgSQL function select_ex1 line 4 at assignment
Here is the code
create table example1(
id serial primary key,
name1 varchar(10),
value1