Does FQL have a NOT NOT NULL operator?

Question

I was messing around with FQL and I have this query:

SELECT created_time, attachment, message FROM stream WHERE source_id = me() LIMIT 1000 

which returns 1000 results, which is most important to me. I would like to filter, for example, on MESSAGE NOT NULL. Is this possible (or something similar) with FQL?

Answer 1

Just adding AND message to the WHERE clause also works - an empty value is considered false FQL.

Answer 2

Add type to the SELECT and to the WHERE add AND type > 0 .