query question

Поиск
Список
Период
Сортировка
От chris mutchler
Тема query question
Дата
Msg-id Pine.BSF.4.10.10009070928430.14286-100000@leibnizcreations.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: lee johnson
Дата:
Сообщение: Re: postgres not allowing new database?
Следующее
От: "Adam Lang"
Дата:
Сообщение: php and pgsql and rpm/compile