Postgres Pro
Downloads
Home   >   mailing lists

How to... in update - Mailing list pgsql-admin

From Marc Soler
Subject How to... in update
Date
Msg-id 014401c2ef93$161b15e0$0300a8c0@terra
Whole thread Raw
Responses Re: How to... in update  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-admin
Tree view 
Hi all,

It's possible in postgres to increment a row in a UPDATE command.

something like this:  UPDATE table set col_name = 'foo', col_name2 ++ WHERE
condition

Thanks.
--
Marc Soler

pgsql-admin by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Index not used on a DISTINCT ON
Next
From: "Nigel Bishop"
Date:
Subject: Any Monitoring Tools for Postgres?