Prepared statements and default values

From: Assad Jarrahian <jarraa(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Prepared statements and default values
Date: 2006-01-10 03:24:37
Message-ID: 4bd3e1480601091924q54cfee5cs1c6744638e650fff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I have a preparedStatement with the following query
"UPDATE usersettings SET gpsfrequency = ? , serverurl = ? where
username = ? ;";

In the db, the table userSettings has a default value specified for
gps_frequency .

So when I write code
if (client.getSettings().getField(Settings.GPS_FREQUENCY).compareTo(""))==0)
<what goes here> //pick up the default value from the db.
else
setUserSettings.setInt(++i,
Integer.parseInt(client.getSettings().getField(Settings.GPS_FREQUENCY)));

<what goes here> .. I basically want to send something that lets the
db know to use the DEFAULT value. (its of type int0)

So what does go here?

any help would be much appreciated.

-a

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Wall 2006-01-10 03:30:37 Re: Prepared statements and default values
Previous Message Jaime Casanova 2006-01-09 17:48:38 Fwd: [BUGS] BUG #2139: Problem when calling functions without any argument