Accessing table attributes from within PlPgSQL
От | Ron Johnson |
---|---|
Тема | Accessing table attributes from within PlPgSQL |
Дата | |
Msg-id | 1021851229.9171.89.camel@rebel обсуждение исходный текст |
Список | pgsql-novice |
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.l.johnson@cox.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 | +---------------------------------------------------------+
В списке pgsql-novice по дате отправления: