Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

In response to Scott Marlowe : > On Sat, Jan 9, 2010 at 2:46 PM, Andreas Kretschmer > wrote: > > Stefan Kaltenbrunner wrote: > > > >> Andreas Kretschmer wrote: > >>> zxo102 ouyang wrote: > >>> > Hi everyone,    I am using postgresql 8.3-beta3. I have a table > 'test' with three fields:

Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

Thanks for your guys' help. I did not know the meaning of betas / alphas things before and just simply downloaded one to use. Now my 8.3 -beta3 version is really in production and get 100 rows of monitoring data per minutes. So far so good. Anyway, I will upgrade it to a latest stable version. With

Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

On Sat, Jan 9, 2010 at 2:46 PM, Andreas Kretschmer wrote: > Stefan Kaltenbrunner wrote: > >> Andreas Kretschmer wrote: >>> zxo102 ouyang wrote: >>> Hi everyone,    I am using postgresql 8.3-beta3. I have a table 'test' with three fields: >>> >>> I'm guessing you mean 8.4-beta3, right?

Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

Stefan Kaltenbrunner wrote: > Andreas Kretschmer wrote: >> zxo102 ouyang wrote: >> >>> Hi everyone,I am using postgresql 8.3-beta3. I have a table >>> 'test' with three fields: >> >> I'm guessing you mean 8.4-beta3, right? > > either of those are unsuitable for any kind of production use...

Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

Andreas Kretschmer wrote: zxo102 ouyang wrote: Hi everyone, I am using postgresql 8.3-beta3. I have a table 'test' with three fields: I'm guessing you mean 8.4-beta3, right? either of those are unsuitable for any kind of production use... Stefan -- Sent via pgsql-general mailing lis

Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

zxo102 ouyang wrote: > Hi everyone, >I am using postgresql 8.3-beta3. I have a table 'test' with three fields: I'm guessing you mean 8.4-beta3, right? > Any suggestions for the best way to get maximum data value and corresponding > "time" for each group of sid in my case? Based on your d

Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

On 09/01/2010 16:43, zxo102 ouyang wrote: > Hi everyone, >I am using postgresql 8.3-beta3. I have a table 'test' with three fields: Without meaning to sound unhelpful, why on earth are you using a beta version when 8.3 was released *ages* ago and has had several bug-fix updates since? I'd lo

[GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

Hi everyone, I am using postgresql 8.3-beta3. I have a table 'test' with three fields: sid data date 11.1 2009-09-01 1:00:00 12.1 2010-01-01 1:00:20 23.1 2009-09-01 1:00:10