UPPER function in CREATE INDEX

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

UPPER function in CREATE INDEX

kwanma
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UPPER function in CREATE INDEX

Fred Toussi-2
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
> [hidden email]
> 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
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UPPER function in CREATE INDEX

kwanma
This post has NOT been accepted by the mailing list yet.
Thanks Fred. Will go with the workaround for now.
Loading...