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

Re: Accessing table attributes from within PlPgSQL

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Ron Johnson' <ron(dot)l(dot)johnson(at)cox(dot)net>,PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Accessing table attributes from within PlPgSQL
Date: 2002-05-20 08:47:38
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F748AF@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-novice
RAISE NOTICE ''%'',x.bar;
should work (not tested it though)
hth,
- Stuart

> -----Original Message-----
> From: Ron Johnson [mailto:ron(dot)l(dot)johnson(at)cox(dot)net]
> Sent: 20 May 2002 00:34
> To: PgSQL Novice ML
> Subject: [NOVICE] Accessing table attributes from within PlPgSQL
> 
> 
> Hi,
> 
> What is the method of accessing fields from within records?
> 
> Apparently, PlPgSQL doesn't these methods
>     raise notice x.bar;
>     raise notice :x.bar;
> It must be something similar, right.
> 
> As always, TIA from this postgresql newbie.
> 
> test2=# select * from foo;
>  bar 
> -----
>    1
>    2
>    3
> (3 rows)
> 
> test2=# create or replace function curstst1() RETURNS INTEGER AS '
> test2'# declare x record;
> test2'# begin
> test2'#     for x in select * from foo loop
> test2'#         raise notice x.bar;
> test2'#     end loop;
> test2'#     return 1;
> test2'# end;
> test2'# ' LANGUAGE 'plpgsql';
> CREATE
> test2=# select curstst1();
> NOTICE:  plpgsql: ERROR during compile of curstst1 near line 4
> ERROR:  parse error at or near "x.bar"
> 
> -- 
> +---------------------------------------------------------+
> | Ron Johnson, Jr.        Home: ron(dot)l(dot)johnson(at)cox(dot)net     |
> | Jefferson, LA  USA      http://ronandheather.dhs.org:81 |
> |                                                         |
> | "I have created a government of whirled peas..."        |
> |   Maharishi Mahesh Yogi, 12-May-2002,                   |
> !   CNN, Larry King Live                                  |
> +---------------------------------------------------------+
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to 
> majordomo(at)postgresql(dot)org
> 

pgsql-novice by date

Next:From: ghinchliffeDate: 2002-05-20 15:29:57
Subject: Transactions over several db sessions
Previous:From: Ron JohnsonDate: 2002-05-20 00:18:28
Subject: Re: Is a randomized default value primary key

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