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
>
