Patrick Scott Pierce wrote:
>
> I run this query:
>
> select distinct task.*
> from project, task
> where task.projid = (select projid from project where custid =
> (select custid from customer where domain = 'atlantahighrise.com')
> and title = 'Initial site design')
> and task.owner = 'ninjaman' order by priority
>
> And get this error:
> ERROR: ComputeDataSize: attribute 0 has len 0
>
At least 6.3 is strict about tables.
The table "project" is not used in the main query,
remove it and it should be OK.
I don't know if this behaviour is intentional or a "feature",
anyone having more insite into this.
regards,
--
---------------------------------------------
Göran Thyni, sysadm, JMS Bildbasen, Kiruna