[SQL] max( bool )?

[Cedar Cox]

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly