All pastes #244086 Raw Edit

Sans nom

public text v1 · immutable
#244086 ·published 2006-11-09 08:11 UTC
rendered paste body
		  UPDATE _element 
		  SET 	 counters = 
		  	COALESCE 
			(
				counters || 
				(
					TG_RELNAME::text => 
					(
						SELECT (COALESCE ((counters->(TG_RELNAME::text))::int, 0) + 1)::text 
						FROM   _element
						WHERE  _element.id = NEW.id
					)
				), 
				(
					TG_RELNAME::text => 
					(
						SELECT (COALESCE ((counters->(TG_RELNAME::text))::int, 0) + 1)::text 
						FROM   _element
						WHERE  _element.id = NEW.id
					)
				)
			)		  
		  WHERE  _element.path @> NEW.path;