Is it at all possible for an executed insert statement to return a select
statement resultset?
Here's an example table:
*CREATE TABLE test (*
* id integer NOT NULL DEFAULT nextval( 'test_id_seq'::regclass ),*
* column_name text*
*);*
*
*
*
*
Here's the table's rule:
*CREATE RULE replace_test AS ON INSERT TO test WHERE EXISTS( SELECT 1 FROM
test WHERE (column_name = NEW.column_name) ) DO INSTEAD SELECT test.id FROM
test WHERE column_name = NEW.column_name;*
*
*
*
*
How would I get the JDBC driver to return the resultset?
-- Daniel