SELECT question

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)

Responses

Browse pgsql-general by date

  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