Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 87BEA476710 for ; Wed, 23 Oct 2002 10:05:47 -0400 (EDT) Received: from hotmail.com (f94.pav1.hotmail.com [64.4.31.94]) by postgresql.org (Postfix) with ESMTP id 754B5476713 for ; Wed, 23 Oct 2002 10:05:46 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 23 Oct 2002 07:05:50 -0700 Received: from 193.136.224.3 by pv1fd.pav1.hotmail.msn.com with HTTP; Wed, 23 Oct 2002 14:05:50 GMT X-Originating-IP: [193.136.224.3] From: "Carlos Sousa" To: pgsql-sql@postgresql.org Subject: problem with a query Date: Wed, 23 Oct 2002 14:05:50 +0000 Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_78c8_531f_1b79" Message-ID: X-OriginalArrivalTime: 23 Oct 2002 14:05:50.0451 (UTC) FILETIME=[4AE10430:01C27A9D] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/294 X-Sequence-Number: 10011 This is a multi-part message in MIME format. ------=_NextPart_000_78c8_531f_1b79 Content-Type: text/plain; format=flowed hi to all i need to do a query to a small postgres database my best efort to the pretended query is in the attached file 'query.txt' but i need that some rows don't be selected of thouse that the query returns. i send in another attached file 'result.txt' with the query result. looking at content of the file you will see some notes at the end of the table (#..) the database as the data to enable the constrution of a school class schedule. In the 'result.txt' all the rows with max=0 were the fisrt to be inserted do the database. each row represent as example math pratical starting at 8:30 for 1:30 at room 3.15 in the bilding CP the rows with max!=0 (1,2,3,...) mean that content of an insert with max=0 was changed [ex diferent time (fiel to_char) or room (field sala) or bilding (field edificio)of the school class]. row with max=1 is a substitution to a row with max=0, row with max=2 substitutes row with max=1 and ... my objective is to obtain all the rows that were not substituted and the ones that represent the last alteration to the shedule i hope the problem was understod thanks for your time _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 ------=_NextPart_000_78c8_531f_1b79 Content-Type: application/octet-stream; name="query.txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="query.txt" c2VsZWN0ICJzYWxhRXZlbnRvIi5lZGlmaWNpbywic2FsYUV2ZW50byIuc2Fs YSxldmVudG8uImlkUGVyaW9kbyIsZXZlbnRvLnZhcixldmVudG8uZGlzY2lw bGluYSxldmVudG8udHVybm8sDQogICAgICAgZXZlbnRvLnBhcnRlLG1heChl dmVudG8uaW5kaWNlKSxldmVudG8udGlwbyxldmVudG8uZHVyYWNhbyx0b19j aGFyKGV2ZW50by5pbmljaW8sJ0hIMjQ6TUknKQ0KICAgICAgIGZyb20gZXZl bnRvIExFRlQgSk9JTiAic2FsYUV2ZW50byIgT04gKGV2ZW50by5kaXNjaXBs aW5hPSJzYWxhRXZlbnRvIi5kaXNjaXBsaW5hIEFORCBldmVudG8udGlwbz0i c2FsYUV2ZW50byIudGlwbw0KICAgICAgIEFORCBldmVudG8ucGFydGU9InNh bGFFdmVudG8iLnBhcnRlIEFORCBldmVudG8uImlkUGVyaW9kbyI9InNhbGFF dmVudG8iLiJpZFBlcmlvZG8iKQ0KICAgICAgIHdoZXJlIGV2ZW50by5kaXNj aXBsaW5hPSdBTEdBJyBBTkQgZXZlbnRvLnRpcG89J1RQJyBBTkQgZXZlbnRv LnZhcj0nRUEnDQogICAgICAgZ3JvdXAgYnkgZXZlbnRvLmRpc2NpcGxpbmEs ZXZlbnRvLnBhcnRlLGV2ZW50by50dXJubyxldmVudG8udmFyLGV2ZW50by50 aXBvLGV2ZW50by5kdXJhY2FvLCJzYWxhRXZlbnRvIi5lZGlmaWNpbywNCiAg ICAgICAic2FsYUV2ZW50byIuc2FsYSxldmVudG8uImlkUGVyaW9kbyIsZXZl bnRvLmluaWNpbyBvcmRlciBieSBldmVudG8udHVybm8sZXZlbnRvLnRpcG87 ------=_NextPart_000_78c8_531f_1b79 Content-Type: application/octet-stream; name="result.txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="result.txt" IGVkaWZpY2lvIHwgc2FsYSAgfCBpZFBlcmlvZG8gfCB2YXIgfCBkaXNjaXBs aW5hIHwgdHVybm8gfCBwYXJ0ZSB8IG1heCB8IHRpcG8gfCBkdXJhY2FvIHwg dG9fY2hhciANCi0tLS0tLS0tLS0rLS0tLS0tLSstLS0tLS0tLS0tLSstLS0t LSstLS0tLS0tLS0tLS0rLS0tLS0tLSstLS0tLS0tKy0tLS0tKy0tLS0tLSst LS0tLS0tLS0rLS0tLS0tLS0tDQogQSAgICAgICAgfCA1ICAgICB8ICAgICAg IDEzNiB8IEVBICB8IEFMR0EgICAgICAgfCAgICAgMSB8IEEgICAgIHwgICAw IHwgVFAgICB8IDAxOjMwICAgfCAxNjozMA0KIENQICAgICAgIHwgMy4xMyAg fCAgICAgICAxMzYgfCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDEgfCBBICAg ICB8ICAgMCB8IFRQICAgfCAwMTozMCAgIHwgMTY6MzANCiBDUCAgICAgICB8 IDMuNyAgIHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAx IHwgQSAgICAgfCAgIDAgfCBUUCAgIHwgMDE6MzAgICB8IDE2OjMwDQogQ1Ag ICAgICAgfCBBbmYuQiB8ICAgICAgIDEzNiB8IEVBICB8IEFMR0EgICAgICAg fCAgICAgMSB8IEEgICAgIHwgICAwIHwgVFAgICB8IDAxOjMwICAgfCAxNjoz MA0KIEogICAgICAgIHwgMTYgICAgfCAgICAgICAxMzYgfCBFQSAgfCBBTEdB ICAgICAgIHwgICAgIDEgfCBBICAgICB8ICAgMCB8IFRQICAgfCAwMTozMCAg IHwgMTY6MzANCiBKICAgICAgICB8IDE3ICAgIHwgICAgICAgMTM2IHwgRUEg IHwgQUxHQSAgICAgICB8ICAgICAxIHwgQSAgICAgfCAgIDAgfCBUUCAgIHwg MDE6MzAgICB8IDE2OjMwDQogSiAgICAgICAgfCA1ICAgICB8ICAgICAgIDEz NiB8IEVBICB8IEFMR0EgICAgICAgfCAgICAgMSB8IEEgICAgIHwgICAwIHwg VFAgICB8IDAxOjMwICAgfCAxNjozMA0KIENQICAgICAgIHwgMy4xMyAgfCAg ICAgICAxMzYgfCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDEgfCBCICAgICB8 ICAgMCB8IFRQICAgfCAwMTozMCAgIHwgMTc6MzANCiBDUCAgICAgICB8IDMu MTggIHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAxIHwg QiAgICAgfCAgIDAgfCBUUCAgIHwgMDE6MzAgICB8IDE3OjMwDQogQ1AgICAg ICAgfCAzLjIxICB8ICAgICAgIDEzNiB8IEVBICB8IEFMR0EgICAgICAgfCAg ICAgMSB8IEIgICAgIHwgICAwIHwgVFAgICB8IDAxOjMwICAgfCAxNzozMA0K IENQICAgICAgIHwgMy41ICAgfCAgICAgICAxMzYgfCBFQSAgfCBBTEdBICAg ICAgIHwgICAgIDEgfCBCICAgICB8ICAgMCB8IFRQICAgfCAwMTozMCAgIHwg MTc6MzANCiBKICAgICAgICB8IDE2ICAgIHwgICAgICAgMTM2IHwgRUEgIHwg QUxHQSAgICAgICB8ICAgICAxIHwgQiAgICAgfCAgIDAgfCBUUCAgIHwgMDE6 MzAgICB8IDE3OjMwDQogSiAgICAgICAgfCAxNyAgICB8ICAgICAgIDEzNiB8 IEVBICB8IEFMR0EgICAgICAgfCAgICAgMSB8IEIgICAgIHwgICAwIHwgVFAg ICB8IDAxOjMwICAgfCAxNzozMA0KIEogICAgICAgIHwgNSAgICAgfCAgICAg ICAxMzYgfCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDEgfCBCICAgICB8ICAg MCB8IFRQICAgfCAwMTozMCAgIHwgMTc6MzANCiBBICAgICAgICB8IDUgICAg IHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAyIHwgQSAg ICAgfCAgIDEgfCBUUCAgIHwgMDE6MzAgICB8IDEzOjMwICAjIG5ldyAxDQog QSAgICAgICAgfCA1ICAgICB8ICAgICAgIDEzNiB8IEVBICB8IEFMR0EgICAg ICAgfCAgICAgMiB8IEEgICAgIHwgICAwIHwgVFAgICB8IDAxOjMwICAgfCAx NTowMCAgIyBvbGQgMQ0KIENQICAgICAgIHwgMy4xMyAgfCAgICAgICAxMzYg fCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDIgfCBBICAgICB8ICAgMSB8IFRQ ICAgfCAwMTozMCAgIHwgMTM6MzAgICMgbmV3IDINCiBDUCAgICAgICB8IDMu MTMgIHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAyIHwg QSAgICAgfCAgIDAgfCBUUCAgIHwgMDE6MzAgICB8IDE1OjAwICAjIG9sZCAy DQogQ1AgICAgICAgfCAzLjcgICB8ICAgICAgIDEzNiB8IEVBICB8IEFMR0Eg ICAgICAgfCAgICAgMiB8IEEgICAgIHwgICAxIHwgVFAgICB8IDAxOjMwICAg fCAxMzozMCAgIyBuZXcgMw0KIENQICAgICAgIHwgMy43ICAgfCAgICAgICAx MzYgfCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDIgfCBBICAgICB8ICAgMCB8 IFRQICAgfCAwMTozMCAgIHwgMTU6MDAgICMgb2xkIDMNCiBDUCAgICAgICB8 IEFuZi5CIHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAy IHwgQSAgICAgfCAgIDEgfCBUUCAgIHwgMDE6MzAgICB8IDEzOjMwICAoLi4u KQ0KIENQICAgICAgIHwgQW5mLkIgfCAgICAgICAxMzYgfCBFQSAgfCBBTEdB ICAgICAgIHwgICAgIDIgfCBBICAgICB8ICAgMCB8IFRQICAgfCAwMTozMCAg IHwgMTU6MDANCiBKICAgICAgICB8IDE2ICAgIHwgICAgICAgMTM2IHwgRUEg IHwgQUxHQSAgICAgICB8ICAgICAyIHwgQSAgICAgfCAgIDEgfCBUUCAgIHwg MDE6MzAgICB8IDEzOjMwDQogSiAgICAgICAgfCAxNiAgICB8ICAgICAgIDEz NiB8IEVBICB8IEFMR0EgICAgICAgfCAgICAgMiB8IEEgICAgIHwgICAwIHwg VFAgICB8IDAxOjMwICAgfCAxNTowMA0KIEogICAgICAgIHwgMTcgICAgfCAg ICAgICAxMzYgfCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDIgfCBBICAgICB8 ICAgMSB8IFRQICAgfCAwMTozMCAgIHwgMTM6MzANCiBKICAgICAgICB8IDE3 ICAgIHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAyIHwg QSAgICAgfCAgIDAgfCBUUCAgIHwgMDE6MzAgICB8IDE1OjAwDQogSiAgICAg ICAgfCA1ICAgICB8ICAgICAgIDEzNiB8IEVBICB8IEFMR0EgICAgICAgfCAg ICAgMiB8IEEgICAgIHwgICAxIHwgVFAgICB8IDAxOjMwICAgfCAxMzozMA0K IEogICAgICAgIHwgNSAgICAgfCAgICAgICAxMzYgfCBFQSAgfCBBTEdBICAg ICAgIHwgICAgIDIgfCBBICAgICB8ICAgMCB8IFRQICAgfCAwMTozMCAgIHwg MTU6MDANCiBDUCAgICAgICB8IDMuMTMgIHwgICAgICAgMTM2IHwgRUEgIHwg QUxHQSAgICAgICB8ICAgICAyIHwgQiAgICAgfCAgIDAgfCBUUCAgIHwgMDE6 MzAgICB8IDE3OjAwDQogQ1AgICAgICAgfCAzLjEzICB8ICAgICAgIDEzNiB8 IEVBICB8IEFMR0EgICAgICAgfCAgICAgMiB8IEIgICAgIHwgICAxIHwgVFAg ICB8IDAxOjMwICAgfCAxODowMA0KIENQICAgICAgIHwgMy4xOCAgfCAgICAg ICAxMzYgfCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDIgfCBCICAgICB8ICAg MCB8IFRQICAgfCAwMTozMCAgIHwgMTc6MDANCiBDUCAgICAgICB8IDMuMTgg IHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAyIHwgQiAg ICAgfCAgIDEgfCBUUCAgIHwgMDE6MzAgICB8IDE4OjAwDQogQ1AgICAgICAg fCAzLjIxICB8ICAgICAgIDEzNiB8IEVBICB8IEFMR0EgICAgICAgfCAgICAg MiB8IEIgICAgIHwgICAwIHwgVFAgICB8IDAxOjMwICAgfCAxNzowMA0KIENQ ICAgICAgIHwgMy4yMSAgfCAgICAgICAxMzYgfCBFQSAgfCBBTEdBICAgICAg IHwgICAgIDIgfCBCICAgICB8ICAgMSB8IFRQICAgfCAwMTozMCAgIHwgMTg6 MDANCiBDUCAgICAgICB8IDMuNSAgIHwgICAgICAgMTM2IHwgRUEgIHwgQUxH QSAgICAgICB8ICAgICAyIHwgQiAgICAgfCAgIDAgfCBUUCAgIHwgMDE6MzAg ICB8IDE3OjAwDQogQ1AgICAgICAgfCAzLjUgICB8ICAgICAgIDEzNiB8IEVB ICB8IEFMR0EgICAgICAgfCAgICAgMiB8IEIgICAgIHwgICAxIHwgVFAgICB8 IDAxOjMwICAgfCAxODowMA0KIEogICAgICAgIHwgMTYgICAgfCAgICAgICAx MzYgfCBFQSAgfCBBTEdBICAgICAgIHwgICAgIDIgfCBCICAgICB8ICAgMCB8 IFRQICAgfCAwMTozMCAgIHwgMTc6MDANCiBKICAgICAgICB8IDE2ICAgIHwg ICAgICAgMTM2IHwgRUEgIHwgQUxHQSAgICAgICB8ICAgICAyIHwgQiAgICAg fCAgIDEgfCBUUCAgIHwgMDE6MzAgICB8IDE4OjAwDQogSiAgICAgICAgfCAx NyAgICB8ICAgICAgIDEzNiB8IEVBICB8IEFMR0EgICAgICAgfCAgICAgMiB8 IEIgICAgIHwgICAwIHwgVFAgICB8IDAxOjMwICAgfCAxNzowMA0KIEogICAg ICAgIHwgMTcgICAgfCAgICAgICAxMzYgfCBFQSAgfCBBTEdBICAgICAgIHwg ICAgIDIgfCBCICAgICB8ICAgMSB8IFRQICAgfCAwMTozMCAgIHwgMTg6MDAN CiBKICAgICAgICB8IDUgICAgIHwgICAgICAgMTM2IHwgRUEgIHwgQUxHQSAg ICAgICB8ICAgICAyIHwgQiAgICAgfCAgIDAgfCBUUCAgIHwgMDE6MzAgICB8 IDE3OjAwDQogSiAgICAgICAgfCA1ICAgICB8ICAgICAgIDEzNiB8IEVBICB8 IEFMR0EgICAgICAgfCAgICAgMiB8IEIgICAgIHwgICAxIHwgVFAgICB8IDAx OjMwICAgfCAxODowMA0KKDQyIHJvd3Mp ------=_NextPart_000_78c8_531f_1b79--