Escape for outer joins

You can specify outer joins using the following syntax: {oj table (LEFT|RIGHT|FULL) OUTER JOIN (table | outer-join) ON search-condition }

For example :

rs = stmt.executeQuery( "select * from {oj a left outer join b on (a.i=b.i)} ");
Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group