All pastes #805728 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-12-04 16:46 UTC
rendered paste body
SELECT parent_id AS id, id AS text_id
FROM   _text
WHERE  parent_id = 1000000004

EXCEPT

SELECT *
FROM 
	xpath_table (
		'id',
		'data',
		'_blog',
		'/data/modules/*/line/column/bloc/id',
		'id = 1000000004 AND xpath_string (data,''/data/modules/*/line/column/bloc/nom_bloc'') = ''text''') 
	AS _xpath (id bigint, text_id bigint)