Hi,
Here's an easy patch for todays snapshot to sort the result of the
public ResultSet getTables(String catalog, String schemaPattern, String
tableNamePattern, String[] types) throws SQLException
method:
Compare:
(<)J:\postgresql-snapshot\src\interfaces\jdbc\org\postgresql\jdbc2\DatabaseMetaData.java
(89441 bytes)
with:
(>)J:\postgresql-snapshot\src\interfaces\jdbc\org\postgresql\jdbc2\DatabaseMetaData.java.orig
(89415 bytes)
1669c1669
< sql.append("' order by relkind, relname");
---
> sql.append("'");
This is required by the JDBC spec: It says "They are ordered by TABLE_TYPE,
TABLE_SCHEM and TABLE_NAME."
<newbie>
I was wondering while looking through the code why outer joins are not used
for certain queries, e.g. in the getTables() method to get the comments for
a particular table.
</newbie>
Cheers,
Jeroen
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
