Skip site navigation (1) Skip section navigation (2)

Re: SQL Work Needed at the City of Wilsonville

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 (view raw or flat)
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.



In response to

Responses

pdxpug by date

Next:From: Lindsey SmithDate: 2011-07-26 17:54:04
Subject: Re: SQL Work Needed at the City of Wilsonville
Previous:From: Shawn HelmDate: 2011-07-26 17:30:56
Subject: Re: SQL Work Needed at the City of Wilsonville

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group