pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: giuseppe.derossi@email.it
To: Ben Kim <bkim@tamu.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: HELP, can't implement e filter
Date: Mon, 20 Aug 2007 16:57:58 +0200
Message-ID: <8a804b41b66f29ab046f6e43715de038@83.224.204.62> (raw)

Hi guys,
thanks to everybody for your help. Sorry if I was not too goot at explaining
my problem, well, I have only the first table and I want to implement a
filter which returns the second one. The rule to implement is:
select only one c1 which has the max c2 and min c4, then display only c3,c4.
and c5 in ascendig way. 
This is my solution, but I think I can improve it by using th Ben'suggestion
:


select c1,c2,c3,min(c4),min(c5)
-- see min c5 works on not significat values
from first_table
into tab_temp
group by c1,c2,c3
order by c1

 

select c1,max(c2),c3,c4,c5
into second_table
from tab_temp
group by c1,c3,c4,c5
order by c1,c4,c5

select c3,c4,c5 from second_table order by c3,c4,c5



	--------- Original Message --------
	Da: Ben Kim <bkim@tamu.edu>
	To: 
	        Cc: pgsql-admin@postgresql.org
	Oggetto: Re: [ADMIN] HELP, can't implement e filter
	Data: 20/08/07 16:15
	
	> 
> 
> 
> On Sun, 19 Aug 2007, giuseppe.derossi@email.it wrote:
> 
> > Hi,
> > I need to implement a filter in order to select from the first table the
> > second one...
> >  c1     c2 c3     c4     c5
> > 1)133659;1;"0039";"00121";7
> > 2)133664;1;"0039";"00121";12
> > 3)133664;2;"0039";"00121";12
> > 4)133665;2;"0039";"00121";12
> > 5)135460;1;"0039";"01152";
> > 6)135460;2;"0039";"01152";
> > 7)135471;1;"0050";"00153";4
> > 8)135471;2;"0050";"00153";4
> >
> > 1)133659;1;"0039";"00121";7
> > 3)133664;2;"0039";"00121";12
> > 4)133665;2;"0039";"00121";12
> > 6)135460;2;"0039";"01152";
> > 8)135471;2;"0050";"00153";4
> 
> There should be something better but this might work.
> 
> select * from testtable where (c1,c2) in (select c1, max(c2) from 
> testtable group by c1 );
> 
> 
> HTH
> 
> Ben K.
> Developer
> http://benix.tamu.edu
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 
> 
>  
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f
 
 Sponsor:
 Collezioni Moda Giro d’Italia Fashion. Approfitta dei saldi estivi. Sconti
dal 30 al 50%. Uomo, Donna e Bambino. Prodotto ufficiale.
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6908&d=20070820





view thread (5+ messages)

Message-ID: <8a804b41b66f29ab046f6e43715de038@83.224.204.62>
Permalink:  ../8a804b41b66f29ab046f6e43715de038@83.224.204.62/
Also on:    postgresql.org/message-id/8a804b41b66f29ab046f6e43715de038@83.224.204.62

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: giuseppe.derossi@email.it, bkim@tamu.edu
  Subject: Re: HELP, can't implement e filter
  In-Reply-To: <8a804b41b66f29ab046f6e43715de038@83.224.204.62>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox