From: | Michelle Konzack <linux4michelle(at)freenet(dot)de> |
---|---|
To: | pgSQL - General <pgsql-general(at)postgresql(dot)org> |
Subject: | SELECT question |
Date: | 2007-08-17 12:27:07 |
Message-ID: | 20070817122707.GV1795@freenet.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-08-17 12:32:31 | Re: Finding my database |
Previous Message | Roy Buyuksimkesyan | 2007-08-17 12:24:33 | tsearch2 query question |