On Nov 19, 2009, at 7:33 AM, Mr Guest wrote: > Hello, > > Are you planning to support constraints with indexes like: > postgres: > CREATE UNIQUE INDEX "lower_name" ON "public"."test" USING btree > (LOWER(text)); > > To be able to search with WHERE LOWER(name) = LOWER(?); > > Best regards, > John
John, Sorry, this message got caught in my spam filter. I can't see any reason not to support that. Would you be interested in looking at SQL::Translator::Parser::PostgreSQL to see if you could extend the grammar for the "CREATE INDEX" statement? If you submitted a patch to the SQLT list, I or someone else would be happy to apply it. Or if you could describe the most generic solution, e.g., "'USING btree' is optional, capture everything up to the semi-colon." ky ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
