Thanks Helen



The performance of your solution is good, but unfortunately I can't change
database structure.

I've thought that there is some modifier to the "order by" clause or
something else.



Best regards,

Anton Malinovskiy





_____

From: Helen Borrie [mailto:helebor@...]
Sent: Monday, April 11, 2005 4:20 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] case sensitive "order by"



At 04:07 PM 11/04/2005 +0700, you wrote:

>Hello everybody,
>
> I've found that select statements like:
>
> select id, name
>
> from Human
>
> order by name;
>
> are case sensitive and the only way for case insensitive "order by" which
>I've found is select statement like:
>
> select id, name, upper(name)
>
> from Human
>
> order by 3;
>
>But this solution doesn't suit me. Is the any other solution?

A well-performing solution for case-insensitive orderings and searches is
to include a proxy column for each column you want this feature for, and
populate it with an insert and an update trigger, e.g.

create trigger pop_proxy for Human
active before insert or update as
begin
new.proxy_name = upper(new.name);
end

Index the proxy column.

./hb





_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]