Re: [SQL] plpgsql select into question

use 'INSERT INTO table1 ... SELECT ... ' stmt in your pgplsql. EXECUTE command is the way to execute a dynamic query in your function, read developer guide PL section of docs. Jie Liang -Original Message- From: J D [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 7:50 AM To: [

[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