Update on existence?

From: Jan Danielsson <jan(dot)m(dot)danielsson(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Update on existence?
Date: 2007-04-05 00:48:40
Message-ID: 46144768.7020704@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello all,

I have a table called sessions, with session ids. Each session also
has a last_access timestamp and some other data. Is is possible (using
PL/pgSQL) to implement something along the line of:

------------------
select id, username, settings from sessions where id='foobar'
If a result was found
update sessions set last_access=current_timestamp where id='foobar'
------------------

Obviously, I want to access the id, username and settings columns if
they are found.

In other words: Is it possible to make something which behaves almost
like a normal "select", but which has some hidden internal magic as
described above?

--
Kind regards,
Jan Danielsson

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2007-04-05 02:56:26 Re: Update on existence?
Previous Message Mark Kelly 2007-04-04 22:52:15 Re: Design advice needed.