| 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 |
| Date: | 1998-03-07 11:21:25 |
| Message-ID: | 35012DB5.4838D288@bildbasen.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 1998-03-07 12:45:03 | Re: Bad interaction between databases |
| Previous Message | Bruce Momjian | 1998-03-07 06:06:12 | Re: [HACKERS] dec alpha/64bit stuff |