Re: [QUESTIONS] Error: ComputeDataSize

I changed the query after sending it (within minutes) and all was and is
well. Thanks.

Patrick Scott Pierce
pspierce(at)mindspring(dot)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(at)bs1(dot)bildbasen(dot)kiruna(dot)se>
> To: Patrick Scott Pierce <pspierce(at)mindspring(dot)net>
> Cc: questions(at)postgresql(dot)org, hackers(at)postgresql(dot)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,
> --
> ---------------------------------------------
> Gran Thyni, sysadm, JMS Bildbasen, Kiruna