Thread: 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@greatgulfhomes.com