--- Tom Allison <tallison(at)tacocat(dot)net> wrote:
> Jeff Eckermann wrote:
> > --- Tom Allison <tallison(at)tacocat(dot)net> wrote:
> >>I seemed to remember being able to do this but I
> >>can't find the docs.
> >>Can I run a sql query to insert new or update
> >>existing rows in one query?
> So I have to watch out for transactions on this?
> Essentially what I'm trying to do is one of the
> following two:
> if exists update a field to field+1 on one record
> if it doesn't exist, insert a row with field = 1
I'm not sure what you are asking here that is not
already covered. I suggest you spend some time
reading the documentation on concurrency, and
searching the archives for some of the lengthy past
discussions on this topic.
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
In response to
pgsql-general by date
|Next:||From: Laura Vance||Date: 2004-05-27 14:21:07|
|Subject: Re: One more time on ONE-TO-MANY|
|Previous:||From: rama||Date: 2004-05-27 13:28:08|
|Subject: statement level triggers in PostgreSQL , anybody??|