pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedChaning locale sorting order for statements
3+ messages / 3 participants
[nested] [flat]
* Chaning locale sorting order for statements
@ 2002-11-16 10:51 Albrecht Berger <berger1517@gmx.ch>
0 siblings, 1 reply; 3+ messages in thread
From: Albrecht Berger @ 2002-11-16 10:51 UTC (permalink / raw)
To: pgsql-sql
Hello,
is it possible to change the locale sorting order in statements ?
I need this for a multilingual web application, where I'm not
able to set the locale in the session or elsewhere.
In Oracle I would use something like that :
SELECT * FROM table1
ORDER BY NLSSORT(column1, 'NLS_SORT=FRENCH');
Does postgres has something similar ?
Thx
berger
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Chaning locale sorting order for statements
@ 2002-11-16 11:01 pginfo <pginfo@t1.unisoftbg.com>
parent: Tomasz Myrta <jasiek@klaster.net>
0 siblings, 0 replies; 3+ messages in thread
From: pginfo @ 2002-11-16 11:01 UTC (permalink / raw)
To: Tomasz Myrta <jasiek@klaster.net>; +Cc: Albrecht Berger <berger1517@gmx.ch>; pgsql-sql
I am not sure about comparation performance.
I have big problems with sort performance in pg by comparing varchar.
Also I am not sure if it is possible to get this new funktion to replace the
standart sort.
regards,
Ivan.
Tomasz Myrta wrote:
> Uz.ytkownik Albrecht Berger napisa?:
> > In Oracle I would use something like that :
> > SELECT * FROM table1
> > ORDER BY NLSSORT(column1, 'NLS_SORT=FRENCH');
> >
> > Does postgres has something similar ?
> I think, you have to create function NLSSORT by your own.
> C language would be nice for performance.
> It is possible to create operator which compares two strings, but I
> don't know how to tell him what the language is used now.
> Regards,
> Tomasz Myrta
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Chaning locale sorting order for statements
@ 2002-11-16 11:56 Tomasz Myrta <jasiek@klaster.net>
parent: Albrecht Berger <berger1517@gmx.ch>
0 siblings, 1 reply; 3+ messages in thread
From: Tomasz Myrta @ 2002-11-16 11:56 UTC (permalink / raw)
To: Albrecht Berger <berger1517@gmx.ch>; +Cc: pgsql-sql
Uz.ytkownik Albrecht Berger napisa?:
> In Oracle I would use something like that :
> SELECT * FROM table1
> ORDER BY NLSSORT(column1, 'NLS_SORT=FRENCH');
>
> Does postgres has something similar ?
I think, you have to create function NLSSORT by your own.
C language would be nice for performance.
It is possible to create operator which compares two strings, but I
don't know how to tell him what the language is used now.
Regards,
Tomasz Myrta
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-11-16 11:56 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-16 10:51 Chaning locale sorting order for statements Albrecht Berger <berger1517@gmx.ch>
2002-11-16 11:56 ` Tomasz Myrta <jasiek@klaster.net>
2002-11-16 11:01 ` pginfo <pginfo@t1.unisoftbg.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox