From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | Paolo Saudin <paolo(at)ecometer(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: R: How to check if 2 series of data are equal |
Date: | 2009-02-12 17:56:32 |
Message-ID: | 1544341303.115741234461392851.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- "Paolo Saudin" <paolo(at)ecometer(dot)it> wrote:
> >-----Messaggio originale-----
> >Da: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] Per conto di Adrian
> Klaver
> >Inviato: giovedì 12 febbraio 2009 17.28
> >A: pgsql-general(at)postgresql(dot)org
> >Cc: Paolo Saudin
> >Oggetto: Re: [GENERAL] How to check if 2 series of data are equal
>
> >On Thursday 12 February 2009 12:06:41 am Paolo Saudin wrote:
> >> Hi,
> >>
> >> I have 14 tables filled with meteorological data, one record per
> parameter
> >> per hour. The id field holds the parameter type (1=temperature,
> 2=humidity
> >> ...) My problem is that for short periods (maybe one week, one
> month) there
> >> are two stations with the same data, I mean the temperature of
> table1 is
> >> equal to the humidity of table3. I need to discover those cases.
>
> >Before I can start to answer this I need some clarification. How can
> temperature
> >and humidity be the same data?
>
> Can be the same data ( and it is ) because of errors in the remote
> stations configurations.
> The Stations and parameters IDs were mixed up resulting in same data
> in different tables ...
>
I am afraid I more confused now. From the table schema the value is a real number only and has no units. As I understand the units designation lies in the id. If the ids are mixed up I can't see how it is possible to differentiate between a value of 25 that maybe degrees C or % relative humidity for instance. You are going to have to step me through this.
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-02-12 18:03:07 | Re: Update table with random values from another table |
Previous Message | Paolo Saudin | 2009-02-12 17:44:37 | R: How to check if 2 series of data are equal |