[HACKERS] Re: COUNT(Distinct city) HELP!!!

2000-12-25 Thread mlw
Abe wrote: > > Hey there, > > Just tried that - No luck - I am using version 6.5.0 - Maybe its just not > available in this version. > Any alternatives ? I have tried this on version 7.02. I assume 6.5 did not support it. > > Thanks Guys, > Abe > - Original Message - > From: "mlw" <[E

[HACKERS] Re: COUNT(Distinct city) HELP!!!

2000-12-25 Thread Abe
Hey there, Just tried that - No luck - I am using version 6.5.0 - Maybe its just not available in this version. Any alternatives ? Thanks Guys, Abe - Original Message - From: "mlw" <[EMAIL PROTECTED]> To: "Abe" <[EMAIL PROTECTED]>; "Hackers List" <[EMAIL PROTECTED]> Sent: Monday, Decembe

[HACKERS] Re: 7.1 on DEC/Alpha

2000-12-25 Thread Brent Verner
On 24 Dec 2000 at 01:19 (-0500), Tom Lane wrote: | Brent Verner <[EMAIL PROTECTED]> writes: | > (gdb) p *resSlot | > Error accessing memory address 0x40141830: Invalid argument. | | Oooh. resSlot has been truncated to 32 bits --- judging by the other | nearby pointer values, it almost certainly

Re: [GENERAL] COUNT(Distinct city) HELP!!!

2000-12-25 Thread Stephan Szabo
I believe that functionality was added in version 7.0, are you using an earlier version? On Mon, 25 Dec 2000, Abe wrote: > Hey there, > > I get this error but I think this is supposed to work: > > The table has some duplicates such as Munich I want the number of distinct cities: > > abenew=>

Re: [HACKERS] Upper limit on number of buffers?

2000-12-25 Thread mlw
Oleg Bartunov wrote: > > /proc/sys/kernel/shmmax I think I am getting a lot of "Homer Simpson" awards this year. The killer is that I have dealt with this problem on another project. Thanks guys. > Oleg > On Sun, 24 Dec 2000, mlw wrote: > > > Date: Sun, 24 Dec 2000 13:52:43 -0500 > >

[HACKERS] Re: COUNT(Distinct city) HELP!!!

2000-12-25 Thread mlw
Abe wrote: > >Part 1.1Type: Plain Text (text/plain) >Encoding: quoted-printable Try this: select count(distinct (city) ) from ct -- http://www.mohawksoft.com

[GENERAL] COUNT(Distinct city) HELP!!!

2000-12-25 Thread Abe
Hey there,   I get this error but I think this is supposed to work:   The table has some duplicates such as Munich I want the number of distinct cities:   abenew=> select * from ct;name|    age|    city        +---  +--jow  |     10| londontim | 15| pariskim |