Re: UPPER function in CREATE INDEX

This may be supported in the future.

HSQLDB already has an alternative. You can create an extra column as
GENERATED ALWAYS AS (UPPER(NAME)) then create a normal index on the
extra column.

Fred

On Fri, Aug 2, 2013, at 11:31, kwanma wrote:
> Hi, would like to know if there is a plan for HSQLDB to support the
> UPPER/LOWER function in INDEX?
> 
> CREATE UNIQUE INDEX IX_NAME ON CONTACT
> (UPPER(NAME));
> 
> Thanks.
> 
> 
> 
> 
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/UPPER-function-in-CREATE-INDEX-tp3937.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent 
> caught up. So what steps can you take to put your SQL databases under 
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent 
caught up. So what steps can you take to put your SQL databases under 
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk