All pastes #243384 Raw Edit

Divers

public text v1 · immutable
·published 2006-11-08 12:18 UTC
rendered paste body
ob2=> select counters->'_blog' from _site; 
 ?column? 
----------
 
(1 row)

ob2=> UPDATE _site SET counters=counters||('_blog' => (select (counters->'_blog')::int + 1 from _site));
UPDATE 1
ob2=> select counters->'_blog' from _site; 
 ?column? 
----------
 
(1 row)