SELECT
 --id,
 LANGUAGE,
 source_id,
 date_part('epoch', pubDate) AS DATE,
 LENGTH(text) AS text,
 COALESCE(LENGTH(title), 0) AS title,

 least(COALESCE(LENGTH(sentences), 0), 1)=1 AS sentences, -- True for NOT NULL

 least(COALESCE(LENGTH(termvector), 0), 1)=1 AS termvector, -- True for NOT NULL

 COALESCE(_calaised, FALSE) AS calaised,
 COALESCE(_analyzed, FALSE) AS analyzed

 FROM documents
 ORDER BY (pubdate) DESC
 LIMIT 10000;