Yes I'm a newbie...
I need to do a nested UPDATE to 2 tables, will this work? (and no I didn't try it... production server)
st.executeUpdate("INSERT INTO Registration(ExpirationDate), Customer(UserName, Password) VALUES (DATETIME(NOW()+" + days + "), "+ username +", "+ password +" WHERE Customer.CustomerID=Registration.CustomerID AND Registration.CustomerID=" + id + ")");
Don't worry to much about the variables and such... just the SQL string.
pgsql-novice by date
|Next:||From: Daniel Åkerud||Date: 2001-07-06 12:40:08|
|Subject: Transactions within a function|
|Previous:||From: R Vijayanath||Date: 2001-07-05 15:33:04|
|Subject: can we write to a flat file from Postgresql procedure|