From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Constraint: string length must be 32 chars |
Date: | 2010-10-17 16:42:54 |
Message-ID: | 4CBB278E.5020502@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alexander Farber wrote:
> Hello, really good advices here! But -
>
> On Sun, Oct 17, 2010 at 2:37 AM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>> I just read the "anonymously" part, so I take it you have ruled out
>> recording the given coordinate components directly, in multiple columns
>> presumably? Otherwise it seems you could then do a) a composite key and b)
>> queries directly against coordinate values.
>>
>
> what do you mean here? Do you suggest using line segments
> instead of points in my records or something else?
>
> Regards
> Alex
>
>
Sorry Alexander, I have to confess here and now that I'm not familiar
with GPS data. My presumption was that it was represented as something
like latitude, longitude (,alitutde?, others?), and that while those
would surely hash nicely with md5 I thought you would be loosing the
inherent information of the position.
From | Date | Subject | |
---|---|---|---|
Next Message | John Iliffe | 2010-10-17 18:53:44 | Re: Automated Database Backups |
Previous Message | Tom Lane | 2010-10-17 14:33:38 | Re: Constraint: string length must be 32 chars |