SELECT question - Mailing list pgsql-general

From Michelle Konzack
Subject SELECT question
Date
Msg-id 20070817122707.GV1795@freenet.de
Whole thread Raw
Responses Re: SELECT question  (Michael Glaesemann <grzm@seespotcode.net>)
List 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)

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum problem
Next
From: "Phoenix Kiula"
Date:
Subject: Re: Some frustrations with admin tasks on PGSQL database