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