From: | Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Re: SQL Work Needed at the City of Wilsonville |
Date: | 2011-07-26 17:37:41 |
Message-ID: | 1E15EA69-8AE5-4134-864C-CEAF45B03910@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
On Jul 26, 2011, at 10:26 AM, gabrielle wrote:
>> On Jul 21, 2011, at 10:10 PM, Lindsey Smith wrote:
>
>>> In their words: "Take 2 tables with the same data in different columns
>>> (owners, addresses, etc) massage the data in SQL then drop it into a
>>> fresh table that we use to update our production database."
>
> Tom commented:
>> Sounds more like a Perl job to me.
>
> Yeah... and deceptively simple. I might call them and find out some
> more details.
>
> Anybody interested in a group PDXPUG hackfest/fundraiser/helping out
> the local gov, or is that a totally insane idea?
>
> gabrielle
>
I was thinking a join or union deal and a select into. I could be grossly underestimating how complex their data is.
I like the idea of a hackfest for this. It would be really interesting to see how everyone goes about this.
Brent D.
From | Date | Subject | |
---|---|---|---|
Next Message | Lindsey Smith | 2011-07-26 17:54:04 | Re: SQL Work Needed at the City of Wilsonville |
Previous Message | Shawn Helm | 2011-07-26 17:30:56 | Re: SQL Work Needed at the City of Wilsonville |