I'd like to have an official edit mode for SQL of PostgreSQL flavour. I propose following entry in the catalog and attached mode file.
<!-- Thiemo Kellner, 2009-08-06 -->
<MODE NAME="PostgreSQL" FILE="pg-sql.xml"
FILE_NAME_GLOB="*.{pg_sql,pg-sql}" />
SQL of PostgreSQL flavour mode
updated to PostgreSQL 9.2 and finally committed in r22821.
Can be tested with
http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=src/test/regress/sql/create_aggregate.sql;hb=HEAD
for COMMENT and the like, and on
http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=src/test/regress/sql/select_implicit.sql;hb=HEAD
for more standard SQL.
Thiemo, if you're still interested in the subject, your comments will be welcome.
Thanks,