Tommy Gildseth wrote:
Sumeet wrote:
Thanks Buddy, really appreciate ur help on this
problem solved...
Is there any way this query can be optimized...i'm running it on a
huge table with joins
ORDER BY rand() is rather slow on large datasets, since the db has to
actually generate a rando
Sumeet wrote:
Thanks Buddy, really appreciate ur help on this
problem solved...
Is there any way this query can be optimized...i'm running it on a
huge table with joins
ORDER BY rand() is rather slow on large datasets, since the db has to
actually generate a random value for each row in
On 2/24/07, Sumeet <[EMAIL PROTECTED]> wrote:
got itI just figured out that i dont need the ORDER BY clause even the
first row selected by the 'DISTINCT ON' would solve the problem.
Dear Sumeet,
if order by is not done there is no certainty about which row gets
selected. usually same r
Thanks Buddy, really appreciate ur help on this
problem solved...
Is there any way this query can be optimized...i'm running it on a huge
table with joins
- Sumeet
On 2/23/07, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote:
On 2/24/07, Sumeet <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'
On 2/24/07, Sumeet <[EMAIL PROTECTED]> wrote:
Hi all,
I'm trying to write a query to select random values from a set of 'GROUP
BY'
see the scenario below to understand the problem here (the actual
problem cannot be discussed here so i'm taking an example scenario)
Assume there is a table
On Fri, 2007-02-23 at 19:25 +0100, Stefan Becker wrote:
> dear SQL friends,
>
> What I want to do might be done differantly. Right now I can't
> think of another solution other than a select statement
>
> I would like to create a sequence range of integer constants. Join
> this sequence against
On Fri, 2007-02-23 at 12:25, Stefan Becker wrote:
> dear SQL friends,
>
> What I want to do might be done differantly. Right now I can't
> think of another solution other than a select statement
>
> I would like to create a sequence range of integer constants. Join
> this sequence against a ID
am Fri, dem 23.02.2007, um 19:25:35 +0100 mailte Stefan Becker folgendes:
> Now: Is there a syntax that allows for the following.
>
> create table XX (id int);
> insert into XX (select xx from "1 to 1000" of integers)
Perhaps you are searching for generate_series():
test=*# select generat
Hi all,
I'm trying to write a query to select random values from a set of 'GROUP
BY'
see the scenario below to understand the problem here (the actual
problem cannot be discussed here so i'm taking an example scenario)
Assume there is a table
id | name | year_of_birth
query: I want to se
dear SQL friends,
What I want to do might be done differantly. Right now I can't
think of another solution other than a select statement
I would like to create a sequence range of integer constants. Join
this sequence against a ID Range in a database and look for missing
Id's.
Another appli
On Fri, 23 Feb 2007, Louis-David Mitterrand wrote:
On Fri, Feb 23, 2007 at 01:31:14PM -0500, Joe wrote:
Hello Louis-David,
On Fri, 2007-02-23 at 17:27 +0100, Louis-David Mitterrand wrote:
I'm considering implementing a search box on my review web site
http://lesculturelles.net and am looking
On Fri, Feb 23, 2007 at 01:31:14PM -0500, Joe wrote:
> Hello Louis-David,
>
> On Fri, 2007-02-23 at 17:27 +0100, Louis-David Mitterrand wrote:
> > I'm considering implementing a search box on my review web site
> > http://lesculturelles.net and am looking for a simple way to match
> > entered wo
I think contrib/tsearch2
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
is what you need.
Oleg
On Fri, 23 Feb 2007, chester c young wrote:
I'm considering implementing a search box on my review web site
http://lesculturelles.net and am looking for a simple way to match
entered words a
Hello Louis-David,
On Fri, 2007-02-23 at 17:27 +0100, Louis-David Mitterrand wrote:
> I'm considering implementing a search box on my review web site
> http://lesculturelles.net and am looking for a simple way to match
> entered words against several columns on related tables: show.show_name,
>
> > create view search_v as select
> > 'show'::name as tab_nm,
> > show_id as tab_pk,
> > 'Show Name' as description,
> > show_name as search
> > from show
> > union select
> > 'story'::name,
> > story_id,
> > 'Story Title',
> > title
> > from story
> > union ...
> >
> What
On Fri, Feb 23, 2007 at 10:01:22AM -0800, chester c young wrote:
> > I'm considering implementing a search box on my review web site
> > http://lesculturelles.net and am looking for a simple way to match
> > entered words against several columns on related tables:
> > show.show_name, story.title,
> I'm considering implementing a search box on my review web site
> http://lesculturelles.net and am looking for a simple way to match
> entered words against several columns on related tables:
> show.show_name, story.title, person.firtname, person.lastname, etc.
one solution would be a view:
c
Hello,
I'm considering implementing a search box on my review web site
http://lesculturelles.net and am looking for a simple way to match
entered words against several columns on related tables: show.show_name,
story.title, person.firtname, person.lastname, etc.
What is the most elegant way to
Yes, but if it was '2004-01-02 01:00:00'-'2004-01-01 00:00:00' it should
return 25:00:00, not 1 day 1:00.
I agree with Tom that this should be changed; I'm just arguing that we
might well need a backwards-compatibility solution for a while. At the
very least we'd need to make this change very clea
19 matches
Mail list logo