Public feed #725269

Stuff

public text v1 · immutable
Raw Edit
·published 2007-10-04 07:24 UTC
rendered paste body
IF NOT EXISTS (SELECT 1 FROM tab WHERE colcode = 'xxx') THEN
INSERT INTO tab (colcode, colname, colversion) VALUES ('tr1', 'MyTree',
'version: 1')
ELSE
UPDATE tab SET colname = 'MyTree', colversion = 'version: 1' WHERE colcode =
'tr1'
END IF