Skip site navigation (1) Skip section navigation (2)

Re: accessing composite value's field in function

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Nikita Koselev" <koselev(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: accessing composite value's field in function
Date: 2008-10-05 14:58:33
Message-ID: 396486430810050758n5a30d4a5h5bc531601c1c9569@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sat, Oct 4, 2008 at 11:59 PM, Nikita Koselev <koselev(at)gmail(dot)com> wrote:

>        RAISE NOTICE rs.name;
> --
> 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?

I think the syntax for the RAISE NOTICE isn't correct.  Notice the
examples in the PostgreSQL manual:
http://www.postgresql.org/docs/8.3/interactive/plpgsql-errors-and-messages.html

Variables like rs.name must be passed into a parametrized message string.


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2008-10-05 15:11:18
Subject: Re: array of composite types - how can I launch this function with an array of composite values
Previous:From: Nikita KoselevDate: 2008-10-05 06:59:20
Subject: accessing composite value's field in function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group