> select id, username, settings from sessions where id='foobar'
this is handled using this link:
However, I seen it mentioned that there is a variable called FOUND that may be used for this also.
It might be worth reading up on.
> If a result was found
this can be achieved from this link:
> update sessions set last_access=current_timestamp where id='foobar'
this is just about correct using the rowtype variable
I hope this helps,
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: Jan Danielsson||Date: 2007-04-05 03:47:30|
|Subject: Re: Update on existence?|
|Previous:||From: Jan Danielsson||Date: 2007-04-05 00:48:40|
|Subject: Update on existence?|