| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-05 15:11:18 | Re: array of composite types - how can I launch this function with an array of composite values |
| Previous Message | Nikita Koselev | 2008-10-05 06:59:20 | accessing composite value's field in function |