Re: [SQL] [BUGS] 7.3 GROUP BY differs from 7.2

2003-02-22 Thread Stephan Szabo
On Fri, 21 Feb 2003, Tom Lane wrote: > Dan Langille <[EMAIL PROTECTED]> writes: > > This is the query in question: > > > SELECT element_id as wle_element_id, COUNT(watch_list_id) > > FROM watch_list JOIN watch_list_element > >ON watch_list.id = watch_list_element.watch_list_id > > WHE

Re: [SQL] [BUGS] 7.3 GROUP BY differs from 7.2

2003-02-22 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Fri, 21 Feb 2003, Tom Lane wrote: >> Anyone care to offer a gloss on the spec to prove that this behavior >> is correct or not correct? > Hmm, I'd read SQL92 Section 7.5 (joined tables) Syntax Rules as saying > that the non natural/using case is separ

Re: [BUGS] Bug #898: client_encoding can't support GB18030

2003-02-22 Thread Tatsuo Ishii
> zzhb ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The lower the number the more severe it is. > > Short Description > client_encoding can't support GB18030 encoding in postgresql 7.3.1 > > Long Description > When I insert records using files, psql -f install.sql > > if I set PGCLIE

[BUGS] psql -F problems

2003-02-22 Thread Hubert depesz Lubaczewski
hi according to docs -F parameter given to psql is equivalent to \f or \pset fieldset in psql itself. this is usually true, but if i'll try to use "tab" as field separator, i cannot enter it like this: psql -c "something" -A -t -F '\t' it just returns fields separated by literally '\t', and not by

Re: [BUGS] psql -F problems

2003-02-22 Thread Peter Eisentraut
Hubert depesz Lubaczewski writes: > this is usually true, but if i'll try to use "tab" as field separator, i > cannot enter it like this: > psql -c "something" -A -t -F '\t' > it just returns fields separated by literally '\t', and not by tab-space > character. This command is parsed by the shell

Re: [BUGS] psql -F problems

2003-02-22 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Hubert depesz Lubaczewski writes: >> this is usually true, but if i'll try to use "tab" as field separator, i >> cannot enter it like this: >> psql -c "something" -A -t -F '\t' >> it just returns fields separated by literally '\t', and not by tab-space

Re: [SQL] [BUGS] 7.3 GROUP BY differs from 7.2

2003-02-22 Thread Stephan Szabo
On Sat, 22 Feb 2003, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > On Fri, 21 Feb 2003, Tom Lane wrote: > >> Anyone care to offer a gloss on the spec to prove that this behavior > >> is correct or not correct? > > > Hmm, I'd read SQL92 Section 7.5 (joined tables) Syntax Rules as