DatabaseMetaData.getTables() doesn't sort its result - Mailing list pgsql-jdbc

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