From: Carlos Sousa <carlosdsousa@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: problem with a query
Date: Wed, 23 Oct 2002 14:05:50 +0000
Message-ID: <F94LAPDVXLuSbh29cM300000459@hotmail.com> (raw)
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=3963Attachments:
query.txt (application/octet-stream, 720B) download
result.txt (application/octet-stream, 4.2K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: carlosdsousa@hotmail.com
Subject: Re: problem with a query
In-Reply-To: <F94LAPDVXLuSbh29cM300000459@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox