Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group