| From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | max( bool )? |
| Date: | 2001-04-04 12:32:57 |
| Message-ID: | Pine.LNX.4.21.0104041417120.7152-100000@nanu.visionforisrael.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Question and a problem:
I have this query
select distinct not exists (
select sc1caption from tblstsc1
where (tblstsc1options.surid like surid || '.%'
or surid=tblstsc1options.surid)
and surid!=tblstsc1options.surid
and sc1caption is not null
)
from tblstsc1options
where '164' like surid || '.%' or surid like '164' || '.%'
;
Which with current data returns two records, one true and one false. What
I want to know is if any of the records (fields) are true. It doesn't
appear max() will do this:
ERROR: Unable to select an aggregate function max(bool)
What can I do? FYI, this query will be run from within a trigger function
(plpgsql).
Now for the problem.. In attempting to get what I want, I wrote this:
select not exists (select distinct max((select sc1caption from tblstsc1
where (tblstsc1options.surid like surid || '.%' or
surid=tblstsc1options.surid) and surid!=tblstsc1options.surid and
sc1caption is not null)) from tblstsc1options where '164' like surid ||
'.%' or surid like '164' || '.%');
And I get this notice:
NOTICE: PortalHeapMemoryFree: 0x0x824a6e8 not in alloc set!
NOTICE: Buffer Leak: [059] (freeNext=54, freePrev=58, relname=tblstsc1,
blockNum=0, flags=0x14, refcount=-4 -1)
Thanks,
-Cedar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tjk@tksoft.com | 2001-04-04 14:22:43 | Re: outer joins |
| Previous Message | Albert REINER | 2001-04-04 11:04:23 | Historical dates in Timestamp |