accessing composite value's field in function

From: "Nikita Koselev" <koselev(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: accessing composite value's field in function
Date: 2008-10-05 06:59:20
Message-ID: 24e54d80810042359j729f9623q41d8925d9ebf8fae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I try to print out field of composite value in my procedure
--

CREATE OR REPLACE FUNCTION add_position(rs requirement_vo )
RETURNS void AS
$BODY$
DECLARE
BEGIN
RAISE NOTICE rs.name;
END;
$BODY$
--
However "rs.name" causes "ERROR: syntax error at or near "rs.name"".
So how should I access composite value's field inside of the function?

--
Nikita Koselev

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma 2008-10-05 14:58:33 Re: accessing composite value's field in function
Previous Message Nikita Koselev 2008-10-05 06:54:10 DESCRIBE for composite type?