[GENERAL] [Newbie] UPDATE based on other table content

ct_id=product.id ; But of course it does what was predictable - ie the qty "field" is incremented only once, even if more than one entry is referencing a given product. But it's not what I was hoping... What would be the "good" solution to do that UPDATE? Thanks for

Re: [GENERAL] [Newbie] UPDATE based on other table content

BY intermediate.product_id ) AS summary WHERE summary.product_id = product.id ; Sorry for disturbance! Daniel Daniel Chiaramello a écrit : Hello. I have a very basic question, relative to the following "problem". I have the following tables: product id qty in

Re: [GENERAL] [Newbie] UPDATE based on other table content

Thom Brown a écrit : ... 2009/10/29 Daniel Chiaramello : Never mind, I found how finally: UPDATE product SET qty = qty+s_count FROM ( SELECT intermediate.product_id, count(*) AS s_count FROM intermediate, orders WHERE

[GENERAL] dblink and commit

Hello. I an wondering how things happen, related to transactions using dblink. I am doing the following thing (simplified, of course), on ServerA: BEGIN insert into TableA_ServerA (...) select * from dblink(ServerB, select * from tableA_Serve

[GENERAL] tsearch dictionary list?

nd of course I don't speak thailandese at all! In fact, is there somewhere a list of existing tsearch dictionaries? Are japanese, chinese, or other "exotic" languages supported by tsearch? Thanks for your attention, Daniel Chiaramello -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] Using ISpell dictionary - headaches...

onnection with the server has been cut unexpectedly. The server may have stop abnormaly before or during the request handling. The connection with the server has been lost. Trying to reinitialization: Failed) I have no idea on what may cause that, nor what I could look for to find idea on how to solve that. It *may* be because I'm using psql 8.0.3 and not the latest version (but I'm stucked with that version), i'm just hoping that one of you have met similar problem and have successfully solved it, or maybe if you know a site where an Ispell dictionary installation is detailed step by step so that I can check if I did something wrong somewhere... Many thanks for your attention, Daniel Chiaramello

[GENERAL] [TextSearch] syntax error while parsing affix file

ot; error line was split on 2 lines). I'm really lost on how I can go further with the bulgarian dictionary... Could you help me, please? Thanks for your attention! Daniel Chiaramello -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] [TSearch2] Chinese dictionary?

ary files themselves... Has one of you managed to instaleld a chinese TSearch2 dictionary on Postgres? Thanks for your attention, Daniel Chiaramello -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [TextSearch] syntax error while parsing affix file

Teodor Sigaev a écrit : iconv -f windows-1251 -t utf-8 bulgarian.dic >bulgarian_utf8.dict iconv -f windows-1251 -t utf-8 bulgarian.aff >bulgarian_utf8.affix The locale of the database is fr_FR, and its encoding is UTF8. I believe that characters 'И', 'А' (non-ascii) and other cyrillic ones are

Re: [GENERAL] [TextSearch] syntax error while parsing affix file

Teodor Sigaev a écrit : I am using Postrges 8.3.5, and I am trying to install a bulgarian ISpell dictionary (the OpenOffice one) for Textsearch features. flag *A: . > А (this is line 24) . > АТА . > И . > ИТЕ OpenOffice or ISpell? Pls, provide: - link to download of dictionary - Locale and en

[GENERAL] (TSearch2] Chinese dictionary?

steps described, I would still have lacked the most important part: the dictionary files themselves... Has one of you managed to installed a chinese TSearch2 dictionary on Postgres? Thanks for your attention, Daniel Chiaramello

Re: [GENERAL] chinese parser for text search !

Hello Oleg and others. I also found that reference, but failed to find the corresponding Chinese dictionary it mentions. And when I tried to compile nlpbamboo, it fails. Has one of you tried (and succeeded) to use Tsearch for Chinese? Thanks for your attention, Daniel Oleg Bartunov a écrit :

Re: [GENERAL] Fulltext search configuration

Hi Mohamed. I don't know where you get the dictionary - I unsuccessfully tried the OpenOffice one by myself (the Ayaspell one), and I had no arabic stopwords file. Renaming the file is supposed to be enough (I did it successfully for Thailandese dictionary) - the ".aff'" file becoming the ".