[PATCHES] please update your website
the link for Farsi FAQ has beed removed from site. please update Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping
[PATCHES] nls_sort function has not beed added in contrib in version 8.1.0
Dear All I had some discussion to convince the maintainer of postgresql to add nls_sort function to the contribution. he accepted to add this function in release of 8.1 but unfortunately he did not. This feature is needed by some governmental organization that we convince them to use postgresql instead of Ms SQL. they want to be sure that this function is added in contribution of postgresql.RegardsWith Regards,--taghi Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping
[PATCHES] Faarsi FAQ?
I asked the list to update the webite and add link for farsi FAQ. I dont know why web site maintainer has not fixed it. Is it necessary to update farsi FAQ for new version of postgresql so that it can be added in web site? With Regards,--taghi Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more.
[PATCHES] farsi faq has not been added yet in website,
would you please fix it, why farsi faq is not in web site?With Regards,--taghi Discover Yahoo! Have fun online with music videos, cool games, IM & more. Check it out!
[PATCHES] Where is Translation of "FARSI" FAQ?
Dear list I had submitter farsi translation of postgresql but I can not find its link in website? would you please fix this problem. Regards Yahoo! Mail Stay connected, organized, and protected. Take the tour
[PATCHES] using strxfrm for having multi locale/please vote for adding this function in contribution
there was a discussion in postgresql mailing list about using strxfrm function to add support multi locale. most of developers agree that this method is a correct but not perfect solution for having multiple locale in postgresql and some people suggest to add such functions in contribution. the main problem of such functions is the overhead of setlocale. (that can be ommited when you run postgresql in a OS with advanced GLIBC and strxfrm_l function) I summerized discussion and add one implementation of such functions, I try to convince tom lane to add this function to the contribution but I failed. maybe you are not interested to this subject but I kindly ask you to say your idea in list. please tell clearly that you are agree/disagree for add this function in contribution or not. I am thankful in advance. With Regards,--taghi Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' nls_sort.tgz Description: nls_sort.tgz ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[PATCHES] again: add collation support function
Sorry I have forgotten to attach the implementaion of nls_sort function. I kindly ask people who concern about support multiple locale per column to verify this implementation and fix it to be suitable for contribuation. Best Regards M. Taghizade __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail nls_sort.tgz Description: nls_sort.tgz ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[PATCHES] add collation support to postgresql
Dear list as you know there was a discussion in list about using nls_string or nls_strxfrm function for having multiple locale at the same time in postgresql. many of developers accepted this method as a correct but not perfect solution. the main problem of this function is using setlocale and its bad performance. I attached this mail one implementation of strxfrm functions (prepared by karl zak) would you please add this function to the contribution so that other people can use this function and do some improvment in it? Best Regards __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[PATCHES] Again!! locale per column for postgreSQL
Qustion: is this approach is suitable for solving the need for locale per column in PostgreSQL ? There is a function I attached to this mail. this function is similar to nls_sort. this function is written by Karel Zak, I dont know if he had tried to submit this code or not. In this distribution you will find file nls_string.c. It contains thedefinition of function nls_string(text, text) which takes a stringparameter and a locale name and returns string describing the ordering.So you can run select * from table order by nls_string(name, 'en_US.UTF-8')or select * from table order by nls_string(name, 'cs_CZ.UTF-8')or select * from table order by nls_string(name, 'C')M. taghizade Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers!
[PATCHES] a simple solution for locale per column
sometimes ago I asked the list if anybody has plan to add locale per column for postgresql or not. I concluded from replies that this need a lot of work. Now we have a sugestion, the most important feature of multiple locale per column is that you can sort different columns based on different locale. if we have a function similiar to nls_sort it can help us to that. there is a function I attached to this mail. this function is similar to nls_sort. this function is written by Karel Zak, I dont know if he had tried to submit this code or not. How it works:In this distribution you will find file nls_string.c. It contains thedefinition of function nls_string(text, text) which takes a stringparameter and a locale name and returns string describing the ordering.So you can run select * from table order by nls_string(name, 'en_US.UTF-8')or select * from table order by nls_string(name, 'cs_CZ.UTF-8')or select * from table order by nls_string(name, 'C')and get what you expect -- the result is sorted the same way as itwould be with LC_COLLATE=locate sort on the command line.Internally, the function sets the locale for LC_COLLATE category, runsstrxfrm on the first parameter and encodes the result as octal values.Thus, it depends on your PostgreSQL collate setting (that which youdid upon initdb, you can check it with show lc_collate) to sortnumbers in the natural way. I believe this is reasonable assumption. M. Taghizadeh Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. postgresql-nls-string-0.53.tar.gz Description: postgresql-nls-string-0.53.tar.gz ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[PATCHES] monetrary prblem
My name : Mahmoud taghizade
My email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) :
Intel Pentium
Operating System (example: Linux 2.4.18) :Linux
2.6.5-1.358 (Fedora core 2)
PostgreSQL version (example: PostgreSQL-7.4.3):
PostgreSQL-7.4.3
Compiler used (example: gcc 2.95.2) : I
used rpm version
Please enter a FULL description of your problem:
when I set lc_monetary to fa_IR.UTF8 and try to insert
a value for field whose type is money I got
following error:
invalid input syntax for type money: "10"
I study the cash.c and found that the problem exists
for any monetary that has not precision.
fa_IR, tr_TR and ...
Please describe a way to repeat the problem. Please
try to provide a
concise reproducible example, if at all possible:
--
create a table with a money type:
CREATE TABLE test ( m money);
and then set lc_monetary to fa_IR.UTF8
now try to insert a value
INSERT INTO test VALUES ('10');
you will get the error message.
now if you set lc_monetary to en_UR.UTF8 (or any
monetary that has precision) you can run the
INSERT INTO test VALUES ('10');
without any error.
If you know how this problem might be fixed, list the
solution below:
-
I have a dirty method to fix the problem, replace the
line 159 in backend/utils/adt/cash.c
if (isdigit((unsigned char) *s) && dec < fpoint)
with
if (isdigit((unsigned char) *s) && (dec < fpoint ||
fpoint == 0))
because the prolem only exists for monetrat with
fpoint == 0;
apply patch:
cp cash.diff to src/backend/utils/adt/ directory
and then patch -p0 < cash.c
now recompile the postgreSQL, the problem will be
fixed.
__
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail*** cash.c 2004-08-22 17:42:57.333775440 +0430
--- cash.c 2004-08-22 17:44:45.840279944 +0430
***
*** 156,162
{
/* we look for digits as int4 as we have less */
/* than the required number of decimal places */
! if (isdigit((unsigned char) *s) && dec < fpoint )
{
value = (value * 10) + *s - '0';
--- 156,162
{
/* we look for digits as int4 as we have less */
/* than the required number of decimal places */
! if (isdigit((unsigned char) *s) && (dec < fpoint || fpoint == 0))
{
value = (value * 10) + *s - '0';
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
