Make update query appear as a select

I need to do either an update, or insert. Rather then get a lock, get a
recordcount, and then perform an UPDATE/INSERT based on the result of my
count, I was hoping to just do the update, and if nothing happened then I
know I need to do an insert...

So, the application is written in ColdFusion, and someone suggested doing
this:
<cfquery name="update_recent"
datasource="#variables.local_datasource_name#">
UPDATE user_recent_list
SET access_stamp = now()
WHERE user_id = '#variables.local_user_id#'
AND app_name = '#variables.local_app_name#';
SELECT @@rowcount as rows_updated;
</cfquery>

But this part:
SELECT @@rowcount as rows_updated;
Does not work on Postgres. Does anyone know what the equivalent statement
is for Postgres?

Thanks

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com