| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | PGSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | creating tables with different character set? |
| Date: | 2001-02-22 07:20:45 |
| Message-ID: | 20010222082045.B1657@depeszws.depesz.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
hi,
i have a problem. i'm living in poland, which has its national characters. of
course they work great under postgresql, but:
when i use non-C locale all ~ '^xxx' and like 'xxx%' searches are not using
index scan.
this is paintful.
for some of the tables i dont need all national characters. in fact i use only
a-z0-9 characters which are subset of standard C-locale character set.
so my question is. is it possible to make a table that way, that it will allow
using indexing when searching for first x characters of string.
at the moment the only solution i got is to make another database (with another
postmaster process), but this is definetly not easy way.
any other options?
depesz
--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2001-02-22 07:28:46 | problem while compiling user c functions in 7.1beta4 |
| Previous Message | newsreader | 2001-02-22 04:52:54 | Re: DBD::Pg is suddenly acting up! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radoslaw Stachowiak | 2001-02-22 09:12:53 | Re: now() with microsecond granulity needed |
| Previous Message | Oliver Elphick | 2001-02-22 06:58:21 | Re: logging a psql script |