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
Sat, 07 Mar 1998 12:21:25 +0100
Goran Thyni <goran@bs1.bildbasen.kiruna.se>
Re: [QUESTIONS] Error: ComputeDataSize
I changed the query after sending it (within minutes) and all was and is
well.  Thanks.

Patrick Scott Pierce
pspierce@mindspring.com
CGI Programming
Mindspring Enterprises




On Sat, 7 Mar 1998, Goran Thyni wrote:

> Date: Sat, 07 Mar 1998 12:21:25 +0100
> From: Goran Thyni <goran@bs1.bildbasen.kiruna.se>
> To: Patrick Scott Pierce <pspierce@mindspring.net>
> Cc: questions@postgresql.org, hackers@postgresql.org
> Subject: Re: [QUESTIONS] Error: ComputeDataSize
> 
> 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


Sat, 7 Mar 1998 09:33:47 -0500 (EST)
Patrick Scott Pierce <pspierce@slacker.design.mindspring.net>
Re: [QUESTIONS] Error: ComputeDataSize