On Fri, Mar 30, 2001 at 06:02:27PM -0800, Soma Interesting wrote:

hmm. maybe it's NEW that's the problem...?

create table gunk( val varchar[] );

insert into gunk values ( '{"first string","another value","the end"}' ) ;

select val[2] from gunk;

val --------------- another value (1 row)

i'd think

table.field[index]

should do the trick, even in plpgsql:

myvar := select name[index] from new;

myvar := new.name[somevariable];

myary := new.name; myvar := myary[someindexvar];

no? (unless <guess> maybe the plpgsql compiler doesn't like variable subscript values </guess>, which would warrant keel hauling everyone responsible...)