Re: [SQL] plpgsql select into question

7:50 AM To: [EMAIL PROTECTED] Subject: [SQL] plpgsql select into question sorry if I've sent this to the wrong list... what is the proper way to do the following from within a plpgsql proc: (where table2 is a variable...) select into user_id max(id) from table2 This is part of a procedure

[SQL] plpgsql select into question

sorry if I've sent this to the wrong list... what is the proper way to do the following from within a plpgsql proc: (where table2 is a variable...) select into user_id max(id) from table2 This is part of a procedure that inserts a new record into table1 (table1 has an auto-incrementing id field