[BUGS] Group by in DIVISION

2008-12-01 Thread JOHN_MCY
hai, I am new to SQL... I am trying to get the result of some mathematical calculation with group by some key. I can get the result without grouping. here with i specified my table information and the SQL i have used to get the result.. can anybody help me to write

Re: [BUGS] Group by in DIVISION

2008-12-01 Thread John R Pierce
JOHN_MCY wrote: hai, I am new to SQL... I am trying to get the result of some mathematical calculation with group by some key. I can get the result without grouping. here with i specified my table information and the SQL i have used to get the result.. can anybody

Re: [BUGS] BUG #4554: download crashes

2008-12-01 Thread Alvaro Herrera
guy barron wrote: > i went on trial with poker tracker did not like> so uninstalled italong with > postgres>then tried holdem manager>went to reinstall postgres. as soon as i > press download it cuts me off from AOL AND PROMPTS me to restart, it also is > not letting me do any downloads at all hav

[BUGS] Fall back to alternative tsearch dictionary directory

2008-12-01 Thread Martin Pitt
Hello all, as recently mentioned on pg-general@, I am currently working on making installed myspell/unspell dictionary packages (which install themselves in /usr/share/myspell/dicts, mostly LATIN encoded) available to PostgreSQL's tsearch/word stemming in Debian/Ubuntu. So far I wrote the postgre

Re: [BUGS] Fall back to alternative tsearch dictionary directory

2008-12-01 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > So far I wrote the postgresql-common infrastructure to mangle these > dictionary/affix files to become palatable for PostgreSQL (recoding to > UTF-8, renaming to lowercase, changing file suffix) and install them > into /var/cache/postgresql/dicts/ whenever

Re: [BUGS] Fall back to alternative tsearch dictionary directory

2008-12-01 Thread Martin Pitt
Hi Tom, Tom Lane [2008-12-01 19:51 -0500]: > I can't see any reason whatever to not put them into > ${sharepath}/tsearch_data/. It's not like you're expecting to be > able to share them with other applications. No, not for sharing. I just don't like them to be in /usr, but that's by and large a