How do you limit results returned from a FETCH?

[emehrkay]

When doing something like

SELECT *, ->posts AS posts FROM user:1 FETCH posts

It will return all posts for a given user. I thought something like SELECT ->(posts LIMIT 3) AS posts would work because you can do where clauses like that, but it doesn't. Is it possible to limit these fetched items?

Also, should ordering work within those parens too?

[tobiemh]

Hi @emehrkay, currently you could do something like the following...

SELECT *, (SELECT ->posts.* FROM $parent LIMIT 3) FROM user:1;