Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DA36E9FB5D1 for ; Wed, 25 Apr 2007 01:47:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56835-04 for ; Wed, 25 Apr 2007 01:47:23 -0300 (ADT) X-Greylist: delayed 00:06:39.619862 by SQLgrey-1.7.4 Received: from web8408.mail.in.yahoo.com (web8408.mail.in.yahoo.com [202.43.219.156]) by postgresql.org (Postfix) with SMTP id C2CC09FB5B5 for ; Wed, 25 Apr 2007 01:47:22 -0300 (ADT) Received: (qmail 77776 invoked by uid 60001); 25 Apr 2007 04:40:40 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=VQdNlRwYWp7lqyWwlur4FvarIcgAHDIHQxb9V+JqnIveks6Vk8LRShJTf6Tvnzd0mnBDg+r3Ozw0tzQmH7CoUxdr8aecAPA9yYHTETtIY+kpPB/GN5InKtFn9gZHwVRbGZWDf9WYdeKIL/cLFbAS0GA8IGxaORDV7FlDGfFWf3Q=; X-YMail-OSG: kbkT_hMVM1kxH4xKs1ZLJBiMzOvU86bWa5IiKrd6KOK2Pm5NCkwqtzBLj5iMTAFBOVfY6r4xBCQTavK2u9VcOz2BuUxju7VB9_QUMvOCOiuZy815W2YutUA75DNY4A-- Received: from [203.199.32.209] by web8408.mail.in.yahoo.com via HTTP; Wed, 25 Apr 2007 10:10:40 IST X-Mailer: YahooMailRC/478 YahooMailWebService/0.7.41.10 Date: Wed, 25 Apr 2007 10:10:40 +0530 (IST) From: saji varghese Subject: Re: hi To: pgsql-sql@postgresql.org, Jim.Wilkinson@cra-arc.gc.ca, "Penchalaiah P." MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2099964809-1177476040=:77086" Message-ID: <311734.77086.qm@web8408.mail.in.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/237 X-Sequence-Number: 28237 --0-2099964809-1177476040=:77086 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi,=0A=0ACan i get GUI tool for PostgreSQLin LINUX.Pls let me know from whe= r i candownload the same.=0A=0ARegards=0ASAJI VERGHESE=0A+919941140433=0A= =0A=0A=0A----- Original Message ----=0AFrom: "Wilkinson, Jim" =0ATo: Penchalaiah P. ; pgsql-sql@= postgresql.org=0ASent: Tuesday, 24 April, 2007 6:15:13 PM=0ASubject: Re: [S= QL] hi=0A=0A=0ASelect sno AS =93SNO=94,=0ASELECT value AS =93VALUE=94,=0A = get_sum(value) as SUM=0A from temp;=0A =0A =0A =0A=0A=0A=0AFrom: pgsql-sql-= owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of P= enchalaiah P.=0ASent: April 24, 2007 8:09 AM=0ATo: pgsql-sql@postgresql.org= =0ASubject: [SQL] hi =0A =0AHi =0AI have the data like this in temp table= =0ASQL> Select sno, value from temp;=0ASNO Value= =0A1 650.00=0A2 850.00=0A3 = 640.00=0A3 985.00=0A5 9= 87.00=0A9 9864.00=0A7 875.00=0ANow,= I want display the result like this=85=0ASQL> Select sno, value, get_sum(v= alue) as sum from temp;=0A SNO Value = SUM=0A1 650.00 650.00=0A2 = 850.00 1500.00 --650+850=0A3 6= 40.00 2140.00 --1500+640=0A3 985.= 00 3125.00 -- 2140+985=0A5 987.00= 4112.00=0A9 9864.00 13976.00=0A7= 875.00 14851.00=0A =0AAny one can tell me = query for this .. I don=92t want any procedure or function=85=0A =0A =0ATha= nks & Regards=0APenchal Reddy=0A =0AInformation transmitted by this e-mail = is proprietary to Infinite Computer Solutions and / or its Customers and is= intended for use only by the individual or the entity to which it is addre= ssed, and may contain information that is privileged, confidential or exemp= t from disclosure under applicable law. If you are not the intended recipie= nt or it appears that this mail has been forwarded to you without proper au= thority, you are notified that any use or dissemination of this information= in any manner is strictly prohibited. In such cases, please notify us imme= diately at info.in@infics.com and delete this email from your records.=0A= =0A=0A Add online presence to your web pages, find out how here - http= ://messenger.yahoo.com/addpresence.php=0A --0-2099964809-1177476040=:77086 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
=0A

 
=0A

Hi,

=0A

 = ;

=0A

Can i get GUI tool for PostgreSQLin LINUX.Pls let me know from w= her i candownload the same.

=0A


Rega= rds
SAJI VERGHESE

=0A

+919941140433

=0A


=0A
----- O= riginal Message ----
From: "Wilkinson, Jim" <Jim.Wilkinson@cra-arc.gc= .ca>
To: Penchalaiah P. <penchalaiahp@infics.com>; pgsql-sql@po= stgresql.org
Sent: Tuesday, 24 April, 2007 6:15:13 PM
Subject: Re: [S= QL] hi

=0A=0A=0A
=0A

Select sno AS =93SNO=94,

=0A

SELECT=  value AS =93VALUE=94,

=0A

 get_sum(value) as SUM<= /P>=0A

 from= temp;

=0A

 

=0A

 

=0A

 

=0A
=0A
=0A
=0A
=0A

From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@po= stgresql.org] On Behalf Of = Penchalaiah P.
Sent: Apr= il 24, 2007 8:09 AM
To: = pgsql-sql@postgresql.org
Subject: [SQL] hi

=0A

 

=0A

Hi

=0A

I have the data like this in temp table

=0A

SQL> Select sno, va= lue from temp;

=0A

SNO     &= nbsp;           &nbs= p;         Value<= /P>=0A

1          &= nbsp;          650.00

=0A

2         &= nbsp;           850.00

=0A

3       &n= bsp;             640= .00

=0A

3      &n= bsp;            &nbs= p; 985.00

=0A

5     &n= bsp;            &nbs= p;  987.00

=0A

9    &= nbsp;            &nb= sp;   9864.00

=0A

7   =              &n= bsp;    875.00

=0A

Now, I want display the result like this= =85

=0A

SQL> Select sno, value, get_sum(value) as sum from temp;

=0A

        SNO  =             &nb= sp;    Value        =       SUM

=0A

1&nb= sp;             = ;       650.00     &= nbsp;       650.00

=0A

2            &= nbsp;        850.00   &nb= sp;         1500.00   &nb= sp;       --650+850

=0A

3            =          640.00   &n= bsp;         2140.00  &nb= sp;        --1500+640

= =0A

3          &nbs= p;          985.00  =            3125.00 &= nbsp;         -- 2140+985

=0A

5         &n= bsp;           987.00&nbs= p;            4112.0= 0

=0A

9      &nb= sp;             = ; 9864.00           13976= .00

=0A

7      &n= bsp;            &nbs= p; 875.00           =   14851.00

=0A

 

= =0A

Any one can tell me query for this .. I don=92t want any pro= cedure or function=85

=0A

 

=0A

&= nbsp;

=0A

Thanks & Regards<= SPAN lang=3DEN-US>

=0A

Penchal Reddy<= SPAN lang=3DEN-US>

=0A

 

=0A=0A=0A=0A
Information transmitted by this e-mail is proprietary to I= nfinite Computer Solutions and / or its Customers and is intended for use o= nly by the individual or the entity to which it is addressed, and may conta= in information that is privileged, confidential or exempt from disclosure u= nder applicable law. If you are not the intended recipient or it appears th= at this mail has been forwarded to you without proper authority, you are no= tified that any use or dissemination of this information in any manner is s= trictly prohibited. In such cases, please notify us immediately at info.in@= infics.com and delete this email from your records.


=0A=0A=0A=0A
= =0ASHOUT IT OUT! Tell everyone, from anywhere, that you're online on Yahoo! Messenger --0-2099964809-1177476040=:77086--