Skip site navigation (1) Skip section navigation (2)

Re: FW: Random Selection from TABLE

From: Salvatore Sferrazza <salzie(at)instigate(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: FW: Random Selection from TABLE
Date: 2001-12-20 22:24:14
Message-ID: Pine.LNX.4.21.0112201720420.16474-100000@queens.instigate.net (view raw or flat)
Thread:
Lists: pgsql-novice
I've implemented something like this before, the way we solved it was by
having a list of "candidate" images in a table indexed by some entity.  We
then used the front end tool (in our case, Java) to select the candidates,
cache them and then pull randomly from the cache upon rendering the
page.  Asking SQL to do this may not be the best idea, since you don't
want one more round-trip per page.

HTH,

Sal

On Fri, 21 Dec 2001, Kris-Jon Fenton wrote:

> Yes, I do have a question, how do I do this?
> 
> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Josh Berkus
> Sent: Friday, 21 December 2001 2:41 AM
> To: Kris-Jon Fenton; pgsql-novice(at)postgresql(dot)org
> Subject: Re: [NOVICE] FW: Random Selection from TABLE
> 
> 
> Kris,
> 
> > I want to be able to select entries randomly so I can change the
> > images on a
> > website using PHP.
> > 
> > Basically I need to have a randomly rotating image that will change
> > whenever
> > the page is refreshed.
> > 
> > I want to store the image names in a table and have them selected
> > from
> > there.
> 
> Sounds like fun!  Do you have a question for the list?
> 
> -Josh
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh(at)agliodbs(dot)com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 


In response to

Responses

pgsql-novice by date

Next:From: Stephen IngramDate: 2001-12-20 22:45:31
Subject: Using a tablename as a parameter to a function.
Previous:From: Kris-Jon FentonDate: 2001-12-20 22:08:47
Subject: Re: FW: Random Selection from TABLE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group