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;
> begi
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),
valu
