Re: [GENERAL] Please change default characterset for database cluster

2007-09-29 Thread CN
On Fri, 28 Sep 2007 21:32:43 -0400, "Carlos Moreno" <[EMAIL PROTECTED]> said: > CN wrote: > > Hi! > > "initdb" use SQL_ASCII as the default characterset encoding when it is > > not given option "-E" and when it can not correctly derive one from > > locale. I suggest "initdb" use UNICODE instead of

Re: [GENERAL] 3 tables join update

2007-09-29 Thread Richard Broersma Jr
--- rihad <[EMAIL PROTECTED]> wrote: > UPDATE Foo foo > SET foo.baz_id=baz.id > FROM Baz baz LEFT JOIN Bar bar ON (foo.bar_id=bar.id) > WHERE bar.id IS NULL; This query cannot work. Basiclly, you are trying to set the foo.baz_id = baz.id for records in foo that do not yet exist. Doing this is i

[GENERAL] 3 tables join update

2007-09-29 Thread rihad
Hi, Say I want to update table Foo with data in table Bar iff left join between Foo and yet another table Baz finds no match. UPDATE Foo foo LEFT JOIN Bar bar ON (foo.bar_id=bar.id) SET foo.baz_id=baz.id FROM Baz baz WHERE bar.id IS NULL; ERROR: syntax error at or near "LEFT" UPDATE Foo fo

Re: [GENERAL] TSearch - Bulgarian

2007-09-29 Thread Hristo Filipov
Hi Christian, Yes we know that we need to create Bulgarian dictionary first. Dictionaries like programs, and dictionaries like word list of our language. The Programs Dictionaries bothers me the most :-). Also how many word list dictionaries we need to build? 1. Stop words. 2. ??? currently we do

Re: [GENERAL] OK, when 8.3 is coming?

2007-09-29 Thread Dave Page
> --- Original Message --- > From: Anton Andreev <[EMAIL PROTECTED]> > To: pgsql-general@postgresql.org > Sent: 29/09/07, 13:33:03 > Subject: [GENERAL] OK, when 8.3 is coming? > > Hi, > > Has someone stated when is Postgresql 8.3 coming? Beta 1 early next week if all goes to plan. Reg

[GENERAL] OK, when 8.3 is coming?

2007-09-29 Thread Anton Andreev
Hi, Has someone stated when is Postgresql 8.3 coming? Anton ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq