Re: Not Strictly LSMB but....

[beamends <..hidden..>]

On Tue, 2008-04-22 at 13:39 -0700, ..hidden.. wrote:
> richard,
> 
> i have not looked into lsmb's schema but in the ole sl schema partnumber
> isn't unique so in the long run it would be a better idea to use id
> instead of partnumber in your where clause. we have thousands of
> partnumber coming from different suppliers and the only way we are able to
> check for unique partnumber amongst the different suppliers was to built a
> unique index on partnumber. however, lsmb's schema change may have taken
> care of this issue.
> 
> regards,
> 
> tim

Hi Tim,
thanks for that. I spent a day (never was into dbases!) trying to figure
out how COPY can select the partnumber to update, but in the end
resorted to creating C program the simply creates a list of

UPDATE parts 
 SET sellprice = '0.34', listprice = '0.34'
 WHERE partnumber = '7316';

for each partnumber in a file, and then as Postgres user did 

psql -d BeamEndsLRSLtd -f
'/home/beamends/Desktop/Projects/StockLoader/Resources/NewPrices.csv'

Not over elegant, but it works!

Cheers
Richard

> 
> > Hi All,
> > I'm trying to get to grips with SQL (who knows, I may even produce
> > something worthwhile for the project!) only having some very basic
> > knowledge. I'm using phppgadmin for SQL type things.
> >
> > A weekly task is updating prices. So far I've got
> >
> > UPDATE parts
> > SET sellprice = 0.34, listprice = 0.34
> > WHERE partnumber = '7316'
> >
> > which is fine, but how do I read a CSV file in? All the examples I've
> > found on the web seem to just "assume" that bit!
> >
> > Thanks in advance.
> >
> > Richard
> >
> > By the by, day one of going live with LSMB went well!
> >
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> > Don't miss this year's exciting event. There's still time to save $100.
> > Use priority code J8TL2D2.
> > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users