WinnipuhТак работет
SELECT (parse(xstring)).tokid as tid,
(parse(xstring)).token as tok from xprop


хочу избавиться от пробелов, так не хочет поскольку во where получается множество
SELECT (parse(xstring)).tokid as tid,
(parse(xstring)).token as tok from xprop
where (parse(xstring)).tokid!=12

так просто не понимает:

SELECT (parse(xstring)).tokid as tid,
(parse(xstring)).token as tok from xprop
where tid!=12

как?
ТАК :
SELECT * FROM (
SELECT (parse(xstring)).tokid as tid, (parse(xstring)).token FROM test.x_s
) q
WHERE tid <> 12;