SELECT question

Поиск
Список
Период
Сортировка
От Michelle Konzack
Тема SELECT question
Дата
Msg-id 20070817122707.GV1795@freenet.de
обсуждение исходный текст
Ответы Re: SELECT question
Список pgsql-general
*********************************************************************
* Do not Cc: me, because I am on THIS list, if I write here.        *
* Keine Cc: an mich, bin auf DIESER Liste wenn ich hier schreibe.   *
* Ne me mettez pas en Cc:, je suis sur CETTE liste, si j'ecris ici. *
*********************************************************************

Hello,

I have a very huge table of references from Websites (html, pics, ...)
where the elements stored on a fileserver using sha384.

Now the indextable hold all filenames and download dates but now I like
to get a "snapshoot on a paticular day.

How must I create the SELCT statement to get ALL files valid on a
particular day?

Note:  There can be every time a new index.html for example but images
       change only once a month...

       So I need all elements valable on the paticular day which mean,
       I need to select that LAST version of the elements...

Greetings
    Michelle Konzack


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSN LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum problem
Следующее
От: "Phoenix Kiula"
Дата:
Сообщение: Re: Some frustrations with admin tasks on PGSQL database