On Tue, 2008-04-22 at 13:39 -0700, [EMAIL PROTECTED] 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 > > [email protected] > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
