| 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: | Whole Thread | Raw Message | 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
| 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. |