Thread: non-standard 'CREATE INDEX' problem

non-standard 'CREATE INDEX' problem

From
n0g0013
Date:
got a vendor application that's pretty much designed for MSSQL but
it's using 'CREATE INDEX ... [ ASC | DESC ]' syntax.

it appears that the ODBC driver is rejecting that as invalid.
testing on the database reveals the same.  and reference to the docs
indicate it's not postgresql syntax.

is there a quick hack allow the driver and the database to accept the
syntax?

--
        t
 t
                 w

Re: non-standard 'CREATE INDEX' problem

From
Jim Nasby
Date:
On Oct 4, 2006, at 12:37 PM, n0g0013 wrote:
got a vendor application that's pretty much designed for MSSQL but
it's using 'CREATE INDEX ... [ ASC | DESC ]' syntax.

it appears that the ODBC driver is rejecting that as invalid.
testing on the database reveals the same.  and reference to the docs
indicate it's not postgresql syntax.

is there a quick hack allow the driver and the database to accept the
syntax?

Quick? Not really. You'd have to modify the grammar, at a minimum.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)