Received: from mail.opentec.com.au ([203.5.51.3]) by hub.org (8.10.1/8.10.1) with ESMTP id e678q8W71034; Fri, 7 Jul 2000 04:52:09 -0400 (EDT) Received: from opentec.com.au (ochre) by mail.opentec.com.au (Sun Internet Mail Server sims.3.5.1999.07.30.00.05.p8) with ESMTP id <0FXB00602KURPX@mail.opentec.com.au>; Fri, 7 Jul 2000 18:56:51 +1000 (EST) Date: Fri, 07 Jul 2000 19:00:14 +1000 From: Paul McGarry Subject: Re: [SQL] MAX() of 0 records. To: Tom Lane Cc: pgsql-bugs@postgresql.org, pgsql-hackers@postgresql.org Message-id: <39659C1E.2E23784E@opentec.com.au> MIME-version: 1.0 X-Mailer: Mozilla 4.61 [en] (Win98; I) Content-type: multipart/mixed; boundary="------------32FE23364D8156C360BAFA28" X-Accept-Language: en References: <396535EF.8132CF80@opentec.com.au> <8477.962940582@sss.pgh.pa.us> <39656BD5.801BDEDC@opentec.com.au> <9124.962953563@sss.pgh.pa.us> X-Archive-Number: 200007/44 This is a multi-part message in MIME format. --------------32FE23364D8156C360BAFA28 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Here's the attachment I said I was going to attach to the last message. TFIF! -- Paul McGarry mailto:paulm@opentec.com.au Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park Road Phone: (02) 9878 1744 North Ryde NSW 2113 Fax: (02) 9878 1755 --------------32FE23364D8156C360BAFA28 Content-Type: application/x-unknown-content-type-sql_auto_file; name="function.sql" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="function.sql" Q1JFQVRFIEZVTkNUSU9OIHNldGVudHJ5cHJpY2VzICgpDQpSRVRVUk5TIE9Q QVFVRSBBUyAnDQoJREVDTEFSRQ0KCQl0ZW1wIElOVDQ7DQoJQkVHSU4NCgkJ SUYgVEdfT1A9JydJTlNFUlQnJyBUSEVODQoJCQl0ZW1wOj1jb3VudCgqKSBG Uk9NIGl0ZW0gd2hlcmUgaXRlbV9lbnRyeV9pZD1ORVcuaXRlbV9lbnRyeV9p ZCBBTkQgaXRlbV9saXZlPScndCcnOw0KCQkJSUYgKHRlbXA+MCkgVEhFTg0K CQkJCVVQREFURSBlbnRyeV9zdGF0cyANCgkJCQlTRVQgZW50cnlfbWF4cHJp Y2U9TUFYKGl0ZW1fcHJpY2UpLA0KCQkJCSAgICBlbnRyeV9taW5wcmljZT1t aW4oaXRlbV9wcmljZSksDQoJCQkJICAgIGVudHJ5X2l0ZW1jb3VudD1jb3Vu dChpdGVtX3ByaWNlKQ0KCQkJCUZST00gaXRlbSANCgkJCQlXSEVSRSBlbnRy eV9zdGF0cy5lbnRyeV9pZD1pdGVtX2VudHJ5X2lkIEFORCBpdGVtX2VudHJ5 X2lkPU5FVy5pdGVtX2VudHJ5X2lkIEFORCBpdGVtX2xpdmU9Jyd0Jyc7DQoJ CQlFTFNFDQoJCQkJVVBEQVRFIGVudHJ5X3N0YXRzDQoJCQkJU0VUIGVudHJ5 X21heHByaWNlPTAsDQoJCQkJICAgIGVudHJ5X21pbnByaWNlPTAsDQoJCQkJ ICAgIGVudHJ5X2l0ZW1jb3VudD0wDQoJCQkJV0hFUkUgZW50cnlfc3RhdHMu ZW50cnlfaWQ9TkVXLml0ZW1fZW50cnlfaWQ7DQoJCQlFTkQgSUY7DQoJCUVO RCBJRjsNCg0KCQlJRiBUR19PUD0nJ0RFTEVURScnIFRIRU4JDQoJCQl0ZW1w Oj1jb3VudCgqKSBGUk9NIGl0ZW0gd2hlcmUgaXRlbV9lbnRyeV9pZD1PTEQu aXRlbV9lbnRyeV9pZCBBTkQgaXRlbV9saXZlPScndCcnOw0KCQkJSUYgKHRl bXA+MCkgVEhFTg0KCQkJCVVQREFURSBlbnRyeV9zdGF0cyANCgkJCQlTRVQg ZW50cnlfbWF4cHJpY2U9TUFYKGl0ZW1fcHJpY2UpLA0KCQkJCSAgICBlbnRy eV9taW5wcmljZT1taW4oaXRlbV9wcmljZSksDQoJCQkJICAgIGVudHJ5X2l0 ZW1jb3VudD1jb3VudChpdGVtX3ByaWNlKQ0KCQkJCUZST00gaXRlbSANCgkJ CQlXSEVSRSBlbnRyeV9zdGF0cy5lbnRyeV9pZD1pdGVtX2VudHJ5X2lkIEFO RCBpdGVtX2VudHJ5X2lkPU9MRC5pdGVtX2VudHJ5X2lkIEFORCBpdGVtX2xp dmU9Jyd0Jyc7DQoJCQlFTFNFDQoJCQkJU0VUIGVudHJ5X21heHByaWNlPTAs DQoJCQkJICAgIGVudHJ5X21pbnByaWNlPTAsDQoJCQkJICAgIGVudHJ5X2l0 ZW1jb3VudD0wDQoJCQkJV0hFUkUgZW50cnlfc3RhdHMuZW50cnlfaWQ9T0xE Lml0ZW1fZW50cnlfaWQ7DQoJCQlFTkQgSUY7DQoJCUVORCBJRjsNCg0KCQlJ RiBUR19PUD0nJ1VQREFURScnIFRIRU4NCgkJCXRlbXA6PWNvdW50KCopIEZS T00gaXRlbSB3aGVyZSBpdGVtX2VudHJ5X2lkPU5FVy5pdGVtX2VudHJ5X2lk IEFORCBpdGVtX2xpdmU9Jyd0Jyc7DQoJCQlJRiAodGVtcD4wKSBUSEVODQoJ CQkJVVBEQVRFIGVudHJ5X3N0YXRzIA0KCQkJCVNFVCBlbnRyeV9tYXhwcmlj ZT1NQVgoaXRlbV9wcmljZSksDQoJCQkJICAgIGVudHJ5X21pbnByaWNlPW1p bihpdGVtX3ByaWNlKSwNCgkJCQkgICAgZW50cnlfaXRlbWNvdW50PWNvdW50 KGl0ZW1fcHJpY2UpDQoJCQkJRlJPTSBpdGVtIHdoZXJlIGVudHJ5X3N0YXRz LmVudHJ5X2lkPWl0ZW1fZW50cnlfaWQgQU5EIGl0ZW1fZW50cnlfaWQ9TkVX Lml0ZW1fZW50cnlfaWQgQU5EIGl0ZW1fbGl2ZT0nJ3QnJzsNCgkJCUVMU0UN CgkJCQlVUERBVEUgZW50cnlfc3RhdHMNCgkJCQlTRVQgZW50cnlfbWF4cHJp Y2U9MCwNCgkJCQkgICAgZW50cnlfbWlucHJpY2U9MCwNCgkJCQkgICAgZW50 cnlfaXRlbWNvdW50PTANCgkJCQlXSEVSRSBlbnRyeV9zdGF0cy5lbnRyeV9p ZD1ORVcuaXRlbV9lbnRyeV9pZDsNCgkJCUVORCBJRjsNCg0KCQkJSUYgTkVX Lml0ZW1fZW50cnlfaWQgIT0gT0xELml0ZW1fZW50cnlfaWQgVEhFTg0KCQkJ CXRlbXA6PWNvdW50KCopIEZST00gaXRlbSB3aGVyZSBpdGVtX2VudHJ5X2lk PU9MRC5pdGVtX2VudHJ5X2lkIEFORCBpdGVtX2xpdmU9Jyd0Jyc7DQoJCQkJ SUYgKHRlbXA+MCkgVEhFTg0KCQkJCQlVUERBVEUgZW50cnlfc3RhdHMgDQoJ CQkJCVNFVCBlbnRyeV9tYXhwcmljZT1NQVgoaXRlbV9wcmljZSksDQoJCQkJ CSAgICBlbnRyeV9taW5wcmljZT1taW4oaXRlbV9wcmljZSksDQoJCQkJCSAg ICBlbnRyeV9pdGVtY291bnQ9Y291bnQoaXRlbV9wcmljZSkNCgkJCQkJRlJP TSBpdGVtIA0KCQkJCQlXSEVSRSBlbnRyeV9zdGF0cy5lbnRyeV9pZD1pdGVt X2VudHJ5X2lkIEFORCBpdGVtX2VudHJ5X2lkPU9MRC5pdGVtX2VudHJ5X2lk IEFORCBpdGVtX2xpdmU9Jyd0Jyc7DQoJCQkJRUxTRQ0KCQkJCQlTRVQgZW50 cnlfbWF4cHJpY2U9MCwNCgkJCQkJICAgIGVudHJ5X21pbnByaWNlPTAsDQoJ CQkJCSAgICBlbnRyeV9pdGVtY291bnQ9MA0KCQkJCQlXSEVSRSBlbnRyeV9z dGF0cy5lbnRyeV9pZD1PTEQuaXRlbV9lbnRyeV9pZDsNCgkJCQlFTkQgSUY7 DQoJCQlFTkQgSUY7DQoJCUVORCBJRjsgDQoJCVJFVFVSTiBOVUxMOw0KCUVO RDsNCicgTEFOR1VBR0UgJ3BscGdzcWwnOw0KDQpDUkVBVEUgVFJJR0dFUiB1 cGRhdGVlbnRyeXByaWNlcyBBRlRFUiBJTlNFUlQgT1IgREVMRVRFIE9SIFVQ REFURSBPTiBpdGVtDQpGT1IgRUFDSCBST1cgRVhFQ1VURSBQUk9DRURVUkUg c2V0ZW50cnlwcmljZXMoKTsNCg== --------------32FE23364D8156C360BAFA28--