Re: [SQL] 'no wait' option for locks

Hi, Why not the program create a lock file on start and delete it when finished. regds mallah. > Hi... > > anyone knows a workaround for Oracles "no wait" option in "SELECT ... > FOR UPDATE"? > > I wrote a programm which runs twice. Both poll the pgsql database all 5 > seconds and make an "SEL

[SQL] "no wait" option for locks

Hi... anyone knows a workaround for Oracles "no wait" option in "SELECT ... FOR UPDATE"? I wrote a programm which runs twice. Both poll the pgsql database all 5 seconds and make an "SELECT ... FOR UPDATE" for the first row found. After some work and commit the next row is processed. The second

[SQL] Float / Numeric ?

Hi Folks, I have an ecommerce application I'm writing and I'm not sure / undecided on a particular way to store shipping rates in PostgreSQL In this application a user may set the shipping rate per item. So I have 3 fields - local,state and international. A forth field, shipping_type (varchar)