Re: [SQL] Problem with array subscripts in plpgsql trigger function

2006-07-05 Thread Erik Jones
Aaron Bono wrote: On 7/5/06, *Erik Jones* <[EMAIL PROTECTED] > wrote: Aaron Bono wrote: > On 7/5/06, *Erik Jones* <[EMAIL PROTECTED] >> wrote: > > Ok, I have a tri

Re: [SQL] Problem with array subscripts in plpgsql trigger function

2006-07-05 Thread Aaron Bono
On 7/5/06, Erik Jones <[EMAIL PROTECTED]> wrote: Aaron Bono wrote:> On 7/5/06, *Erik Jones* <[EMAIL PROTECTED] [EMAIL PROTECTED]>> wrote:>> Ok, I have a trigger set up on the following (stripped down) table: >> CREATE TABLE members (> member_id   bigint,> member_status_id   smallint

Re: [SQL] Problem with array subscripts in plpgsql trigger function

2006-07-05 Thread Erik Jones
Aaron Bono wrote: On 7/5/06, *Erik Jones* <[EMAIL PROTECTED] > wrote: Ok, I have a trigger set up on the following (stripped down) table: CREATE TABLE members ( member_id bigint, member_status_id smallint, member_is_deletedboolean );

Re: [SQL] Problem with array subscripts in plpgsql trigger function

2006-07-05 Thread Aaron Bono
On 7/5/06, Erik Jones <[EMAIL PROTECTED]> wrote: Ok, I have a trigger set up on the following (stripped down) table:CREATE TABLE members (member_id   bigint,member_status_id   smallint,member_is_deletedboolean);Here's a shortened version of the trigger function: CREATE OR REPLACE FUNCTION updat

[SQL] Problem with array subscripts in plpgsql trigger function

2006-07-05 Thread Erik Jones
Ok, I have a trigger set up on the following (stripped down) table: CREATE TABLE members ( member_id bigint, member_status_id smallint, member_is_deletedboolean ); Here's a shortened version of the trigger function: CREATE OR REPLACE FUNCTION update_member() RETURNS TRIGGER AS $um$ DECL