Hi,
I'm having trouble with a query using multiple joins, one of which is an
outer join:
SELECT * FROM posts
LEFT OUTER JOIN post_files ON post_files.Post = posts.Key
JOIN files ON post_files.File = files.Key
I think the type system assumes that posts_files.File will exist even
though a post might not have any associated files, and end ups with this:
Can't resolve type class instance
Class constraint:
{Post_files :
{File : nullify string string,
Post : nullify int (option int)}}
Reduced to unresolvable:
{File : nullify string string,
Post : nullify int (option int)}
Is this query resolvable in some way?
Cheers.
_______________________________________________
Ur mailing list
[email protected]
http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
