What database backend do you use?
On Sat, Jan 31, 2009 at 6:44 PM, omat <o...@gezgin.com> wrote:
>
> Hi all,
>
> I obtain a list of tag ids by:
> tag_ids = TaggedItem.objects.all().order_by('-added__max').annotate(Max
> ('added'))[:10]
>
> and try to use it in the following query to obtain tag objects:
> Tag.objects.filter(id__in=tag_ids)
>
> But i get "invalid reference to FROM-clause" error:
>
> Caught an exception while rendering: invalid reference to FROM-clause
> entry for table "tagging_taggeditem"
> LINE 1: ...RE "tagging_tag"."id" IN (SELECT U0."tag_id", MAX
> ("tagging_t...
> ^
> HINT: Perhaps you meant to reference the table alias "u0".
>
>
> If I force the first query to be evaluated, using the step syntax (ie
> [:10:1] instead of [:10]), then everthing works fine.
>
> Seems like a bug?
>
> ps: I am using a recent svn version.
>
>
> Thanks...
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
