From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: [NOVICE] update question
To: DAVID KUCHARSKI <dave@iemco.com>, josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Date: Tue, 08 Oct 2002 08:39:45 -0700
Message-ID: <web-1775421@davinci.ethosmedia.com>
In-Reply-To: <3DA20957.B8E9A00A@iemco.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

David,

I'm sorry, you just don't seem to be at the "self-help" stage.  I
strongly reccommend that you hire a database consultant to help you.

-Josh Berkus


 DAVID KUCHARSKI <dave@iemco.com> wrote:
> the result set of the view is 3628 lines.  It would be
> nice if postgres could do this update instead of our
> data entry person.
> 
> 
> Josh Berkus wrote:
> > 
> > David,
> > 
> > > > > > 1) Is there any way you can easily identify the relevant
> rows in the
> > > > legacy
> > > > > > database and export only those?
> > >
> > > I guess I'm unclear as to which table you are
> > > referring to as the LEGACY table.  either way i
> > > imagine that by looking at a table  or VIEW of the pik
> > > numbers common to both tables is what i need, so yes I
> > > can get that. in fact i have now. but how can i use
> > > that table to update the price fields in inventory
> > 
> > No, I'm talking about the database system that is exporting to
> text.  Can you
> > tell it to export only the rows you need?
> > 
> > --
> > -Josh Berkus
> >  Aglio Database Solutions
> >  San Francisco
>