Re: non-standard 'CREATE INDEX' problem

[Jim Nasby <jim@xxxxxxxxx>]

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@xxxxxxxxx

EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)