query question - Mailing list pgsql-general

From chris mutchler
Subject query question
Date
Msg-id Pine.BSF.4.10.10009070928430.14286-100000@leibnizcreations.com
Whole thread Raw
List pgsql-general
I am new to using postgresql and have the following question.  if i submit
a query (through a perl script), what values (and in what order) will be
returned to me?  here is my query:

        SELECT p.ids_name, m.start_time, m.end_time
        FROM mail_schedule m, personnel p
        WHERE p.ids_int = m.ids_int AND
        m.dow = $weekday AND
        $timestamp BETWEEN m.start_time AND m.end_time
        UNION
        SELECT p.ids_name, c.on_start, c.on_end
        FROM mail_changes c, personnel p
        WHERE p.ids_int = c.ids_int AND
        $timestamp BETWEEN c.on_start AND c.on_end
        EXCEPT
        SELECT p.ids_name, c.off_start, c.off_end
        FROM mail_changes c, personnel p
        WHERE p.ids_int = c.ids_int AND
        $timestamp BETWEEN c.off_start AND c.off_end

thanks in advance for any assistance you can provide.
chris mutchler
davron@leibnizcreations.com


pgsql-general by date:

Previous
From: lee johnson
Date:
Subject: Re: postgres not allowing new database?
Next
From: "Adam Lang"
Date:
Subject: php and pgsql and rpm/compile