Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f34FHJ841364 for ; Wed, 4 Apr 2001 11:17:19 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f34FGWw07039; Wed, 4 Apr 2001 11:16:36 -0400 (EDT) To: Cedar Cox cc: pgsql-sql@postgresql.org Subject: Re: max( bool )? In-reply-to: References: Comments: In-reply-to Cedar Cox message dated "Wed, 04 Apr 2001 14:32:57 +0200" Date: Wed, 04 Apr 2001 11:16:31 -0400 Message-ID: <7036.986397391@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/44 X-Sequence-Number: 2383 Cedar Cox writes: > 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) (a) What Postgres version is this? (b) Could we see the schemas for the tables? (pg_dump -s output is the best way) regards, tom lane