From oceanlz@yahoo.com.cn Wed Oct 16 03:11:43 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B2EF1475F7F for ; Tue, 15 Oct 2002 23:11:43 -0400 (EDT) Received: from web15106.mail.bjs.yahoo.com (unknown [61.135.128.151]) by postgresql.org (Postfix) with SMTP id 27477475E75 for ; Tue, 15 Oct 2002 23:11:41 -0400 (EDT) Message-ID: <20021016031142.34492.qmail@web15106.mail.bjs.yahoo.com> Received: from [61.152.125.82] by web15106.mail.bjs.yahoo.com via HTTP; Wed, 16 Oct 2002 11:11:42 CST Date: Wed, 16 Oct 2002 11:11:42 +0800 (CST) From: =?gb2312?q?lz=20John?= Subject: hi To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1283634865-1034737902=:32999" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/219 X-Sequence-Number: 9936 --0-1283634865-1034737902=:32999 Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit i'd like to tranfer sql schema from MS server Example: *******************1********************************* if exists (select * from sysobjects where id = object_id(N'[admin].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [admin].[test] go *******************2********************************* CREATE TABLE [admin].[test] ( [test_name] [char] (50) NOT NULL , [test_value] [int] NOT NULL ) i can only realize part 2 and must need the fuction that can check data table. create table test( test_name char (50) not null, test_value int not null ) thanks for any advice!! --------------------------------- Do You Yahoo!? 雅虎娱乐新鲜到底,电子周报快乐到家! --0-1283634865-1034737902=:32999 Content-Type: text/html; charset=gb2312 Content-Transfer-Encoding: 8bit i'd like to tranfer sql schema from MS server
Example:
*******************1*********************************
if exists (select * from sysobjects
where id = object_id(N'[admin].[test]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [admin].[test]
go
*******************2*********************************
CREATE TABLE [admin].[test] (
[test_name] [char] (50) NOT NULL ,
[test_value] [int] NOT NULL
)

i can only realize part 2 and must need the fuction that can check data table.
create table test(
test_name char (50) not null,
test_value int not null
)
thanks for any advice!!

Do You Yahoo!?
雅虎娱乐新鲜到底,电子周报快乐到家! --0-1283634865-1034737902=:32999-- From mike.hepworth@pbs.proquest.com Thu Oct 17 18:20:51 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BA95547590C for ; Thu, 17 Oct 2002 14:20:51 -0400 (EDT) Received: from slexc1.server.power.bellhow.com (slc-fw1.bellhow.com [63.121.54.230]) by postgresql.org (Postfix) with ESMTP id C80A2475425 for ; Thu, 17 Oct 2002 14:20:50 -0400 (EDT) Received: by slexc1a.server.power.bellhow.com with Internet Mail Service (5.5.2653.19) id ; Thu, 17 Oct 2002 12:20:51 -0600 Message-ID: <560796A29B821F40A277973FB5EA3004034AC9@slexc1a.server.power.bellhow.com> From: "Hepworth, Mike" To: "'pgsql-sql@postgresql.org'" Subject: Re: [pgadmin-support] hi Date: Thu, 17 Oct 2002 12:20:06 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C27609.D1B839D0" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/227 X-Sequence-Number: 9944 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C27609.D1B839D0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable lz, =20 You could use the plpgsql function language and create a function that tests for the existence of the file and drop it if it does. =20 Something like this: =20 select dropTableIfExists('test'); =20 The dropTableIfExists would be the plpgsql function that you would need to write. =20 Later, =20 Mike Hepworth...... -----Original Message----- From: lz John [mailto:oceanlz@yahoo.com.cn] Sent: Thursday, October 17, 2002 1:07 AM To: pgsql-sql-owner@postgresql.org Cc: pgsql-general@postgresql.org Subject: [pgadmin-support] hi i don't send mail to pgsql-sql@postgresql.org ,but i need help how to migrate sql from MS sql server to postgresql? i'd like to tranfer sql schema from MS server Example: *******************1********************************* if exists (select * from sysobjects=20 where id =3D object_id(N'[admin].[test]') and=20 OBJECTPROPERTY(id, N'IsUserTable') =3D 1) drop table [admin].[test]=20 go *******************2********************************* CREATE TABLE [admin].[test] ( [test_name] [char] (50) NOT NULL , [test_value] [int] NOT NULL=20 ) i can only realize part 2. i don't know how to realize part 1.in other words, i want to know how to check if a table exist in postgresql *******************2********************************* create table test( test_name char (50) not null, test_value int not null ) thanks for any advice!! _____=20=20 Do You Yahoo!? "=B7=A2=B6=CC=D0=C5=D3=AE=CA=D6=BB=FA,=BF=EC=C0=B4=B2=CE=BC=D3=D1=C5=BB=A2= =BE=DE=D0=C7=D0=E3!" =20 ------_=_NextPart_001_01C27609.D1B839D0 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable

lz,

You=20 could use the plpgsql function language and create a function that tests fo= r the=20 existence of the file and drop it if it does.

Something like this:

select=20 dropTableIfExists('test');

The=20 dropTableIfExists would be the plpgsql function that you would need to=20 write.

Later,

Mike=20 Hepworth......

-----Original Message-----
From: lz John=20 [mailto:oceanlz@yahoo.com.cn]
Sent: Thursday, October 17, 2002 = 1:07=20 AM
To: pgsql-sql-owner@postgresql.org
Cc:=20 pgsql-general@postgresql.org
Subject: [pgadmin-support]=20 hi

i don't send mail to pgsql-sql@postgresql.org,but= i need=20 help

how to migrate sql from MS sql server to postgresql?

i'd like to tranfer sql schema from MS=20 server
Example:
*******************1*******************************= **
if=20 exists (select * from sysobjects
where id =3D object_id(N'[admin].[te= st]')=20 and
OBJECTPROPERTY(id, N'IsUserTable') =3D 1)
drop table [admin].[= test]=20
go
*******************2*********************************
CREATE= =20 TABLE [admin].[test] (
[test_name] [char] (50) NOT NULL ,
[test_val= ue]=20 [int] NOT NULL
)
   i can only realize part 2. i don't k= now=20 how to realize part 1.in other words,
i want to know how to check if a= =20 table exist in=20 postgresql
*******************2*********************************
&n= bsp;=20 create table test(
   test_name char (50) not=20 null,
   test_value int not null
)
thanks for a= ny=20 advice!!

Do You Yahoo!?
"=B7=A2=B6=CC=D0=C5=D3=AE=CA=D6=BB=FA,=BF=EC=C0=B4=B2=CE= =BC=D3=D1=C5=BB=A2=BE=DE=D0=C7=D0=E3!"

------_=_NextPart_001_01C27609.D1B839D0-- From vasundharb@gmail.com Sun Nov 7 06:54:30 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0EAF23A4239 for ; Sun, 7 Nov 2004 06:54:30 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05706-03 for ; Sun, 7 Nov 2004 06:54:22 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 39D233A4255 for ; Sun, 7 Nov 2004 06:54:22 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id iA76sLJ7006643 for ; Sun, 7 Nov 2004 06:54:21 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id iA76jZFk004416 for pgsql-sql@postgresql.org; Sun, 7 Nov 2004 06:45:35 GMT From: vasundharb@gmail.com (vasundhar) X-Newsgroups: comp.databases.postgresql.sql Subject: Hi Date: 6 Nov 2004 22:45:36 -0800 Organization: http://groups.google.com Lines: 4 Message-ID: <2b53db1d.0411062245.56dcb1b5@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/69 X-Sequence-Number: 19388 Hi I am using REL on which only 7.3.2 PG only available and I want to upgrade it to the latest and also integrate it with Perl but my system is also not supporting the DBI any suggestions please From sklassen@commandprompt.com Mon Nov 8 15:57:39 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C4CE43A3F1A for ; Mon, 8 Nov 2004 15:57:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23928-10 for ; Mon, 8 Nov 2004 15:57:16 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 68E413A3B0B for ; Mon, 8 Nov 2004 15:57:18 +0000 (GMT) Received: (from sklassen@localhost) by hosting.commandprompt.com (8.11.6/8.11.6) id iA8FvED13936; Mon, 8 Nov 2004 07:57:14 -0800 Date: Mon, 8 Nov 2004 07:57:14 -0800 From: Steven Klassen To: vasundhar Cc: pgsql-sql@postgresql.org Subject: Re: Hi Message-ID: <20041108155714.GF10081@commandprompt.com> References: <2b53db1d.0411062245.56dcb1b5@posting.google.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2b53db1d.0411062245.56dcb1b5@posting.google.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/73 X-Sequence-Number: 19392 * vasundhar [2004-11-06 22:45:36 -0800]: > Hi I am using REL on which only 7.3.2 PG only available and I want > to upgrade it to the latest and also integrate it with Perl but my > system is also not supporting the DBI any suggestions please My suggestion would be to determine why your system won't support DBI and fix it. -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 From penchalaiahp@infics.com Tue Apr 24 12:39:57 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D65CC9FBBA9 for ; Tue, 24 Apr 2007 09:39:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 32962-04 for ; Tue, 24 Apr 2007 09:39:27 -0300 (ADT) X-Greylist: delayed 00:30:14.564284 by SQLgrey-1.7.4 Received: from gateway.infics.com (gateway.infics.com [202.54.39.20]) by postgresql.org (Postfix) with ESMTP id 567D79FB833 for ; Tue, 24 Apr 2007 09:39:23 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C78669.5B3E1386" Subject: hi Date: Tue, 24 Apr 2007 17:39:05 +0530 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: hi Thread-Index: AceGaVrXzeAnlAhdTMCVI9c6fYHGqA== From: "Penchalaiah P." To: X-imss-version: 2.046 X-imss-result: Passed X-imss-scanInfo: M:B L:E SM:3 X-imss-tmaseResult: TT:1 TS:-8.0186 TC:1F TRN:63 TV:3.6.1039(15134.003) X-imss-scores: Clean:57.14829 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:3 C:4 M:4 S:4 R:4 (0.5000 0.5000) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/227 X-Sequence-Number: 28227 This is a multi-part message in MIME format. ------_=_NextPart_001_01C78669.5B3E1386 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi=0D I have the data like this in temp table SQL> Select sno, value from temp; SNO Value 1 650.00 2 850.00 3 640.00 3 985.00 5 987.00 9 9864.00 7 875.00 Now, I want display the result like this... SQL> Select sno, value, get_sum(value) as sum from temp; SNO Value SUM 1 650.00 650.00 2 850.00 1500.00 --650+850 3 640.00 2140.00 --1500+640 3 985.00 3125.00 -- 2140+985 5 987.00 4112.00 9 9864.00 13976.00 7 875.00 14851.00 =0D Any one can tell me query for this .. I don't want any procedure or function... =0D =0D Thanks & Regards Penchal Reddy =0D Information 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 addressed, and may contain= information that is privileged, confidential or exempt from disclosure= under applicable law. If you are not the intended recipient or it appears= that this mail has been forwarded to you without proper authority, you are= notified that any use or dissemination of this information in any manner= is strictly prohibited. In such cases, please notify us immediately at= info.in@infics.com and delete this email from your records. ------_=_NextPart_001_01C78669.5B3E1386 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have the data like this in temp table

SQL> Select sno, value from= temp;

SNO = &nb= sp; Value

1 &nbs= p; = 650.00

2 &nbs= p; = 850.00

3 &nbs= p; = 640.00

3 &nbs= p; = 985.00

5 &nbs= p; = 987.00

9 &nbs= p; = 9864.00

7 &nbs= p; = 875.00

Now, I want display the result like= this…

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

SNO = Value &nbs= p; SUM

1 &nbs= p; 650.00 &nb= sp; 650.00

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

3 &nbs= p; 640.00 &nb= sp; 2140.00 = --1500+640

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

5 &nbs= p; 987.00 &nb= sp; 4112.00

9 &nbs= p; 9864.00 = 13976.00

7 &nbs= p; 875.00 &nb= sp; 14851.00

Any one can tell me query for this= .. I don’t want any procedure or function…

Thanks &= Regards

Penchal= Reddy

Information= 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 addressed, and may contain information that is= privileged, confidential or exempt from disclosure under applicable law.= If you are not the intended recipient or it appears that this mail has= been forwarded to you without proper authority, you are notified that any= use or dissemination of this information in any manner is strictly= prohibited. In such cases, please notify us immediately at= info.in@infics.com and delete this email from your records.

------_=_NextPart_001_01C78669.5B3E1386-- From Jim.Wilkinson@cra-arc.gc.ca Tue Apr 24 12:45:21 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 50D559FBB4E for ; Tue, 24 Apr 2007 09:45:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 33274-09 for ; Tue, 24 Apr 2007 09:45:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail103.cra-arc.gc.ca (mail103.cra-arc.gc.ca [198.103.184.26]) by postgresql.org (Postfix) with ESMTP id CFB259FBC2B for ; Tue, 24 Apr 2007 09:45:15 -0300 (ADT) Received: from SD01ITMB02.PROD.NET (unknown [7.32.10.168]) by mail103.cra-arc.gc.ca (mail) with ESMTP id 6F3B588M72; Tue, 24 Apr 2007 08:45:14 -0400 (EDT) Received: from SD01ITMV12.PROD.NET ([7.32.10.12]) by SD01ITMB02.PROD.NET with Microsoft SMTPSVC(6.0.3790.2499); Tue, 24 Apr 2007 08:45:14 -0400 x-mimeole: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7866E.671916A3" Subject: Re: hi Date: Tue, 24 Apr 2007 08:45:13 -0400 Message-ID: <7CCC5BEF5E72394C963E529B54EB4A642A1A10@SD01ITMV12.PROD.NET> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] hi Thread-Index: AceGaVrXzeAnlAhdTMCVI9c6fYHGqAABMMmw From: "Wilkinson, Jim" To: "Penchalaiah P." , X-OriginalArrivalTime: 24 Apr 2007 12:45:14.0372 (UTC) FILETIME=[6776EC40:01C7866E] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.586 tagged_above=0 required=5 tests=AWL=-1.138, BAYES_05=-1.11, HTML_MESSAGE=0.001, HTML_TEXT_AFTER_BODY=0.115, RCVD_ILLEGAL_IP=0.288, RCVD_IN_WHOIS_BOGONS=2.43 X-Spam-Level: X-Archive-Number: 200704/229 X-Sequence-Number: 28229 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7866E.671916A3 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Select sno AS "SNO", SELECT value AS "VALUE", get_sum(value) as SUM from temp; =20 =20 =20 ________________________________ From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Penchalaiah P. Sent: April 24, 2007 8:09 AM To: pgsql-sql@postgresql.org Subject: [SQL] hi=20 =20 Hi=20 I have the data like this in temp table SQL> Select sno, value from temp; SNO Value 1 650.00 2 850.00 3 640.00 3 985.00 5 987.00 9 9864.00 7 875.00 Now, I want display the result like this... SQL> Select sno, value, get_sum(value) as sum from temp; SNO Value SUM 1 650.00 650.00 2 850.00 1500.00 --650+850 3 640.00 2140.00 --1500+640 3 985.00 3125.00 -- 2140+985 5 987.00 4112.00 9 9864.00 13976.00 7 875.00 14851.00 =20 Any one can tell me query for this .. I don't want any procedure or function... =20 =20 Thanks & Regards Penchal Reddy =20 Information 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 addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email from your records. =09 ------_=_NextPart_001_01C7866E.671916A3 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Select sno AS = “SNO”,

SELECT value AS = “VALUE”,

get_sum(value) as SUM

from temp;

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

I have the data like this in temp table

SQL> Select sno, value from = temp;

SNO &nb= sp; &nbs= p; Value

1 &nb= sp; = 650.00

2 &nb= sp; = 850.00

3 &nb= sp; = 640.00

3 &nb= sp; = 985.00

5 &nb= sp; = 987.00

9 &nb= sp; = 9864.00

7 &nb= sp; = 875.00

Now, I want display the result like = this…

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

= SNO &nbs= p; Value &n= bsp; SUM

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

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

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

3 &nb= sp; 985.00 &= nbsp; 3125.00 -- = 2140+985

5 &nb= sp; 987.00 &= nbsp; 4112.00

9 &nb= sp; 9864.00 = 13976.00

7 &nb= sp; 875.00 &= nbsp; 14851.00

Any one can tell me = query for this .. I don’t want any procedure or = function…

Thanks & Regards

Penchal Reddy

Information = 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 addressed, and may contain information that is = privileged, confidential or exempt from disclosure under applicable law. = If you are not the intended recipient or it appears that this mail has = been forwarded to you without proper authority, you are notified that = any use or dissemination of this information in any manner is strictly = prohibited. In such cases, please notify us immediately at = info.in@infics.com and delete this email from your records.

------_=_NextPart_001_01C7866E.671916A3-- From ml_flegl@centrum.cz Tue Apr 24 13:07:06 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A76919FBA8B for ; Tue, 24 Apr 2007 10:07:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 43840-02 for ; Tue, 24 Apr 2007 10:06:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail1008.centrum.cz (mail1008.centrum.cz [213.29.7.89]) by postgresql.org (Postfix) with ESMTP id C965D9FBCC6 for ; Tue, 24 Apr 2007 10:06:52 -0300 (ADT) Received: by mail1008.centrum.cz id S10864270AbXDXNGm (ORCPT ); Tue, 24 Apr 2007 15:06:42 +0200 Received: from 85.160.69.40 by mail1008.centrum.cz (Centrum Mail) with HTTP Date: Tue, 24 Apr 2007 15:06:42 +0200 From: "David Flegl" To: X-Mailer: Centrum Mail 1.0 MIME-Version: 1.0 X-Priority: 3 Message-ID: <200704241506.20350@centrum.cz> References: In-Reply-To: Subject: Re: hi Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/230 X-Sequence-Number: 28230 Hi, try this. It's working... SELECT t1.sno, sum(t2.value) FROM temp as t1, temp as t2 WHERE t1.sno >= t2.sno GROUP BY t1.sno; but not completely. The problem is the this suppose your sno is uniqu. But as I see 3 is not. Anyway it may help you. >I have the data like this in temp table > >SQL> Select sno, value from temp; > >SNO Value > >1 650.00 > >2 850.00 > >3 640.00 > >3 985.00 > >5 987.00 > >9 9864.00 > >7 875.00 > >Now, I want display the result like this... > >SQL> Select sno, value, get_sum(value) as sum from temp; > > SNO Value SUM > >1 650.00 650.00 > >2 850.00 1500.00 --650+850 > >3 640.00 2140.00 --1500+640 > >3 985.00 3125.00 -- 2140+985 > >5 987.00 4112.00 > >9 9864.00 13976.00 > >7 875.00 14851.00 > > > >Any one can tell me query for this .. I don't want any procedure or >function... > > > > > >Thanks & Regards > >Penchal Reddy > > > > > >Information 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 addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email from your records. > From gnari@hive.is Tue Apr 24 14:46:15 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AD7509FB8BE for ; Tue, 24 Apr 2007 11:46:15 -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 43166-06 for ; Tue, 24 Apr 2007 11:46:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx2.ipf.is (scania.ipf.is [85.197.192.147]) by postgresql.org (Postfix) with ESMTP id 1D1509FB892 for ; Tue, 24 Apr 2007 11:46:06 -0300 (ADT) Received: (qmail 8008 invoked by uid 1010); 24 Apr 2007 14:44:20 +0000 Received: from 88.149.106.19 by scania (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88/1235. spamassassin: 3.1.1. perlscan: 1.25-st-qms. Clear:RC:1(88.149.106.19):SA:0(-2.1/4.5):. Processed in 0.539116 secs); 24 Apr 2007 14:44:20 -0000 X-Antivirus-IPF-Mail-From: gnari@hive.is via scania X-Antivirus-IPF: 1.25-st-qms (Clear:RC:1(88.149.106.19):SA:0(-2.1/4.5):. Processed in 0.539116 secs Process 8001) Received: from dsl-149-106-19.hive.is (HELO ?192.168.1.33?) (88.149.106.19) by mx2.ipf.is with SMTP; 24 Apr 2007 14:44:19 +0000 Subject: Re: hi From: Ragnar To: "Penchalaiah P." Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset=ISO-8859-1 Date: Tue, 24 Apr 2007 15:05:29 +0000 Message-Id: <1177427129.15187.44.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/232 X-Sequence-Number: 28232 On 䌷i, 2007-04-24 at 17:39 +0530, Penchalaiah P. wrote: > Hi > > I have the data like this in temp table > > SQL> Select sno, value from temp; you seem to be assuming a specific order for this. gnari From sszabo@megazone.bigpanda.com Tue Apr 24 16:41:43 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C43369FB682 for ; Tue, 24 Apr 2007 13:41:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05723-05 for ; Tue, 24 Apr 2007 13:41:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by postgresql.org (Postfix) with ESMTP id 02BA69FB6BA for ; Tue, 24 Apr 2007 13:41:27 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id E167C3552E; Tue, 24 Apr 2007 09:41:26 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id DFC7B3552C; Tue, 24 Apr 2007 09:41:26 -0700 (PDT) Date: Tue, 24 Apr 2007 09:41:26 -0700 (PDT) From: Stephan Szabo To: "Penchalaiah P." Cc: pgsql-sql@postgresql.org Subject: Re: hi In-Reply-To: Message-ID: <20070424092234.V55902@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/234 X-Sequence-Number: 28234 On Tue, 24 Apr 2007, Penchalaiah P. wrote: > Hi > > I have the data like this in temp table > > SQL> Select sno, value from temp; > > SNO Value > > 1 650.00 > > 2 850.00 > > 3 640.00 > > 3 985.00 > > 5 987.00 > > 9 9864.00 > > 7 875.00 Tables are not ordered. You'll need something like an ordering column that represents the ordering and is unique. Then you can probably do something like (untested): select sno, value, (select sum(value) as sum from temp t where t.ordering <= temp.ordering) from temp order by ordering; or select t1.sno, t1.value, sum(t2.value) from temp as t1, temp as t2 where t1.ordering >= t2.ordering group by t1.ordering, t1.sno, t1.value order by t1.ordering; From sajiv_smrt83@yahoo.co.in Wed Apr 25 04:47:27 2007 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

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

----- 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

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

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

&= 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-- From phillip.smith@weatherbeeta.com.au Wed Apr 25 05:16:11 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id EECC69FB378 for ; Wed, 25 Apr 2007 02:16:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 23273-09 for ; Wed, 25 Apr 2007 02:16:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 25CF49FB724 for ; Wed, 25 Apr 2007 02:15:17 -0300 (ADT) Received: (qmail 31458 invoked from network); 25 Apr 2007 05:15:14 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;6c348799b9e3d7067309e9acab8f4896; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 25 Apr 2007 05:15:13 -0000 Received: (qmail 396 invoked by uid 1166); 25 Apr 2007 15:15:09 +1000 Received: from 203.214.90.62 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:0(203.214.90.62):. Processed in 0.350355 secs); 25 Apr 2007 05:15:09 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:0(203.214.90.62):. Processed in 0.350355 secs Process 387) Received: from 203-214-90-62.dyn.iinet.net.au (HELO ?192.168.1.253?) (phillip.smith@weatherbeeta.com.au@203.214.90.62) by mail.weatherbeeta.com.au with SMTP; 25 Apr 2007 15:15:07 +1000 Subject: Re: hi From: Phillip Smith Reply-To: phillip.smith@weatherbeeta.com.au To: saji varghese Cc: pgsql-sql@postgresql.org In-Reply-To: <311734.77086.qm@web8408.mail.in.yahoo.com> References: <311734.77086.qm@web8408.mail.in.yahoo.com> Content-Type: multipart/alternative; boundary="=-W4qw4K87dYrVMkUqHP8P" Organization: Weatherbeeta P/L Date: Wed, 25 Apr 2007 15:19:42 +1000 Message-Id: <1177478382.4706.5.camel@fukawi2.homelinux.net> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1177478113.815-31447-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.03/0.17 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/238 X-Sequence-Number: 28238 --=-W4qw4K87dYrVMkUqHP8P Content-Type: text/plain Content-Transfer-Encoding: 7bit Try pgAdmin - Google will find it for you. ~p On Wed, 2007-04-25 at 10:10 +0530, saji varghese wrote: > > Hi, > Can i get GUI tool for PostgreSQLin LINUX.Pls let me know from wher i > candownload the same. > *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments --=-W4qw4K87dYrVMkUqHP8P Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Try pgAdmin - Google will find it for you.

~p

On Wed, 2007-04-25 at 10:10 +0530, saji varghese wrote:

Hi,
Can i get GUI tool for PostgreSQLin LINUX.Pls let me know from wher i candownload the same.

*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email.

Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments
--=-W4qw4K87dYrVMkUqHP8P-- From postgres@herakles.homelinux.org Sun May 6 23:42:50 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 929AF9FB635 for ; Sun, 6 May 2007 20:42:50 -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 73809-04-6 for ; Sun, 6 May 2007 20:42:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from www.herakles.homelinux.org (coco2.arach.net.au [203.34.16.107]) by postgresql.org (Postfix) with ESMTP id EAE479FB675 for ; Sun, 6 May 2007 20:42:46 -0300 (ADT) Received: from mail.herakles.homelinux.org (unknown [192.168.7.254]) by www.herakles.homelinux.org (Postfix) with ESMTP id A16BA5F51E9 for ; Mon, 7 May 2007 07:42:43 +0800 (WST) Received: from mail2.cds.merseine.nu (unknown [192.168.9.4]) by mail.herakles.homelinux.org (Postfix) with ESMTP id 3878D1EAAF for ; Mon, 7 May 2007 07:42:45 +0800 (WST) Received: from [192.168.9.146] (Bilby.demo.lan [192.168.9.146]) by mail2.cds.merseine.nu (Postfix) with ESMTP id 6338ACAC001 for ; Mon, 7 May 2007 07:42:40 +0800 (WST) Message-ID: <463E67EF.5080905@herakles.homelinux.org> Date: Mon, 07 May 2007 07:42:39 +0800 From: John Summerfield User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20061007 SeaMonkey/1.0.5 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: hi References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/37 X-Sequence-Number: 28318 Penchalaiah P. wrote: > Information transmitted by this e-mail is proprietary to Infinite Computer Solutions It may be proprietary, but it shore ain't confidential! From lew@nospam.lewscanon.com Fri May 18 12:43:46 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 93E0A9FC2BC for ; Fri, 18 May 2007 09:43:46 -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 18740-02 for ; Fri, 18 May 2007 09:43:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 861F39FC2AC for ; Fri, 18 May 2007 09:43:45 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id ED5B230AF7; Fri, 18 May 2007 14:43:42 +0200 (MET DST) Date: Fri, 18 May 2007 08:43:41 -0400 From: Lew User-Agent: Thunderbird 1.5.0.9 (X11/20070102) MIME-Version: 1.0 X-Newsgroups: pgsql.sql Subject: Re: hi References: <463E67EF.5080905@herakles.homelinux.org> In-Reply-To: <463E67EF.5080905@herakles.homelinux.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Lines: 23 X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.34 To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/146 X-Sequence-Number: 28426 John Summerfield wrote: > Penchalaiah P. wrote: > >> Information transmitted by this e-mail is proprietary to Infinite >> Computer Solutions > > It may be proprietary, but it shore ain't confidential! Placing "confidential" on every document without regard for its content, especially when some of it's publicly disseminated, can remove the protection of confidentiality at law from all such marked documents in many jurisdictions, including the U.S. There must be discrimination applied in the marking of information as "confidential". Quite aside from the foolishness you pointed out of marking something "confidential" then placing it into the public eye in an archived forum where it will be visible by everybody forever. Now we can publish everything ever written at or by Infinite Computer Solutions without fear of liability. -- Lew From penchalaiahp@infics.com Mon Jul 30 08:11:30 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BC04E9FB517 for ; Mon, 30 Jul 2007 05:11:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 44622-09 for ; Mon, 30 Jul 2007 05:11:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gateway.infics.com (gateway.infics.com [202.54.39.20]) by postgresql.org (Postfix) with ESMTP id 6E4FD9FB4DE for ; Mon, 30 Jul 2007 05:11:22 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7D281.35F6BC3A" Subject: hi Date: Mon, 30 Jul 2007 13:41:19 +0530 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: hi Thread-Index: AcfSgTWqukDv7fS+TgeJ5MtYGEkv6w== From: "Penchalaiah P." To: "Vivekananda Swamy Ramayanam" X-imss-version: 2.047 X-imss-result: Passed X-imss-scanInfo: M:B L:E SM:3 X-imss-tmaseResult: TT:1 TS:-8.8718 TC:1F TRN:62 TV:3.6.1039(15326.001) X-imss-scores: Clean:99.90000 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:3 C:4 M:4 S:4 R:4 (0.5000 0.5000) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/183 X-Sequence-Number: 28918 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7D281.35F6BC3A Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =0D I want to fix the pay based on joining date and antedate...antedate is the last date... Joining date is 01-07-2007 Antedate is 04-07-2005.. =0D On joining date I will fix the pay but before fixing the pay I will check whether antedate is there or not, if its there then I will see difference between 2 dates..if difference is 2 years then I will fix the pay with increments...if difference is less than 2 years then I will fix the pay with out increments... Take an example of above 2 dates..there is no 2 years difference between two dates... 01-07-2007 I will fix the pay...after 3 days current date =3D antedate...so again I have to fix the pay with out my intervention... Is there any jobs or schedules or triggers to call that function when current date and antedate is equal... =0D =0D Thanks & Regards Penchal Reddy =0D Information 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 addressed, and may contain= information that is privileged, confidential or exempt from disclosure= under applicable law. If you are not the intended recipient or it appears= that this mail has been forwarded to you without proper authority, you are= notified that any use or dissemination of this information in any manner= is strictly prohibited. In such cases, please notify us immediately at= info.in@infics.com and delete this email from your records. ------_=_NextPart_001_01C7D281.35F6BC3A Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I want to fix the pay based on joining date and antedate…antedate is the last= date…

Joining date is 01-07-2007

Antedate is = 04-07-2005..

On joining date I will fix the pay but before fixing the= pay I will check whether antedate is there or not, if its there then I will see difference between 2 dates..if difference is 2 years then I will fix the= pay with increments…if difference is less than 2 years then I will fix= the pay with out increments…

Take an example of above 2 dates..there is no 2 years difference between two dates…

01-07-2007 I will fix the pay…after 3 days current date =3D antedate…so again I have to fix the pay with out my intervention…

Is there any jobs or schedules or triggers to call that function when current date and antedate is= equal…

Thanks &= Regards

Penchal= Reddy

------_=_NextPart_001_01C7D281.35F6BC3A-- From mokhtary@kth.se Sat Sep 10 21:24:13 2011 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4C7DEB5DBC8 for ; Sat, 10 Sep 2011 18:24:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 74469-01 for ; Sat, 10 Sep 2011 21:24:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-1.sys.kth.se (smtp-1.sys.kth.se [130.237.32.175]) by mail.postgresql.org (Postfix) with ESMTP id D5560B5DBC5 for ; Sat, 10 Sep 2011 18:24:06 -0300 (ADT) Received: from mailscan-1.sys.kth.se (mailscan-1.sys.kth.se [130.237.32.91]) by smtp-1.sys.kth.se (Postfix) with ESMTP id 0E20B156333 for ; Sat, 10 Sep 2011 23:24:06 +0200 (CEST) X-Virus-Scanned: by amavisd-new at kth.se Received: from smtp-1.sys.kth.se ([130.237.32.175]) by mailscan-1.sys.kth.se (mailscan-1.sys.kth.se [130.237.32.91]) (amavisd-new, port 10024) with LMTP id pCsbG8NDofQp for ; Sat, 10 Sep 2011 23:24:04 +0200 (CEST) Received: from EXHUB1.ug.kth.se (exhub1.ug.kth.se [130.237.32.134]) by smtp-1.sys.kth.se (Postfix) with ESMTP id D8783156AEE for ; Sat, 10 Sep 2011 23:24:04 +0200 (CEST) Received: from EXDB3.ug.kth.se ([169.254.3.208]) by EXHUB1.ug.kth.se ([130.237.32.134]) with mapi id 14.01.0289.001; Sat, 10 Sep 2011 23:22:33 +0200 From: Mandana Mokhtary To: "pgsql-sql@postgresql.org" Subject: FW: Hi Thread-Topic: Hi Thread-Index: Acxv/58an+OKVrIYQ6SMCp8dIjiOnQAAB1f7 Date: Sat, 10 Sep 2011 21:22:32 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-GB, sv-SE, en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [213.103.192.141] Content-Type: multipart/alternative; boundary="_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.403 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/19 X-Sequence-Number: 35819 --_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ________________________________ From: Mandana Mokhtary Sent: 10 September 2011 23:21 To: pgsql-sql-owner@postgresql.org Subject: Hi Hi All I tried to import shapfile into postgres using this comand: pgsql -c -s 3006 -W LATIN1 c:/...... |psql _U postgres (database name) I could import some but not all. I got this error that I do not have any idea about it: current transaction is aborted, commands ignored until end of transactions = block. at fisrt, the name of the shapfiles have some Swedish alphabet which i chan= ged it to latin I would appreciate any help. Regards, Mandana --_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

From: Mandana Mokhtary
Sent: 10 September 2011 23:21
To: pgsql-sql-owner@postgresql.org
Subject: Hi

Hi All
I tried to import shapfile into postgres using this comand:

pgsql -c -s 3006 -W LATIN1 c:/...... |psql _U postgres (database name= )

I could import some but not all.
I got this error that I do not have any idea about it:

current transaction is aborted, commands ignored until end of transactions = block.

at fisrt, the name of the shapfiles have some Swedish alphabet which i chan= ged it to latin

I would appreciate any help.

Regards, Mandana

--_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_-- From mokhtary@kth.se Sat Sep 10 21:24:27 2011 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 92344B5DC4B for ; Sat, 10 Sep 2011 18:24:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 46377-08 for ; Sat, 10 Sep 2011 21:24:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-1.sys.kth.se (smtp-1.sys.kth.se [130.237.32.175]) by mail.postgresql.org (Postfix) with ESMTP id 68DD5B5DBC5 for ; Sat, 10 Sep 2011 18:24:21 -0300 (ADT) Received: from mailscan-1.sys.kth.se (mailscan-1.sys.kth.se [130.237.32.91]) by smtp-1.sys.kth.se (Postfix) with ESMTP id 2D7A8156B74 for ; Sat, 10 Sep 2011 23:24:21 +0200 (CEST) X-Virus-Scanned: by amavisd-new at kth.se Received: from smtp-1.sys.kth.se ([130.237.32.175]) by mailscan-1.sys.kth.se (mailscan-1.sys.kth.se [130.237.32.91]) (amavisd-new, port 10024) with LMTP id OxmKRFXjdWtl for ; Sat, 10 Sep 2011 23:24:19 +0200 (CEST) Received: from EXHUB1.ug.kth.se (exhub1.ug.kth.se [130.237.32.134]) by smtp-1.sys.kth.se (Postfix) with ESMTP id 7305B156B35 for ; Sat, 10 Sep 2011 23:24:19 +0200 (CEST) Received: from EXDB3.ug.kth.se ([169.254.3.208]) by EXHUB1.ug.kth.se ([130.237.32.134]) with mapi id 14.01.0289.001; Sat, 10 Sep 2011 23:22:41 +0200 From: Mandana Mokhtary To: "pgsql-sql@postgresql.org" Subject: FW: Hi Thread-Topic: Hi Thread-Index: Acxv+JszbO0hsYvsT0OjgSp0y49BYQAByjSn Date: Sat, 10 Sep 2011 21:22:41 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-GB, sv-SE, en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [213.103.192.141] Content-Type: multipart/alternative; boundary="_000_A9344FE6ED34A04F9BF550E6EAAAA31710611947EXDB3ugkthse_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.403 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/20 X-Sequence-Number: 35820 --_000_A9344FE6ED34A04F9BF550E6EAAAA31710611947EXDB3ugkthse_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ________________________________ From: Mandana Mokhtary Sent: 10 September 2011 22:31 To: pgsql-sql-owner@postgresql.org Subject: Hi Hi I am running Get Capabilities application under Apache Tomcat which some ho= w connected to postgre in order to retreie data. I am facing with this error LOG: unexpected EOF on client connection which I don not have any idea about it. Any help to solve this error would be so appreciated. Regards, Mandana --_000_A9344FE6ED34A04F9BF550E6EAAAA31710611947EXDB3ugkthse_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

From: Mandana Mokhtary
Sent: 10 September 2011 22:31
To: pgsql-sql-owner@postgresql.org
Subject: Hi

Hi

I am running Get Capabilities application under Apache Tomcat which some ho= w connected to postgre in order to retreie data.
I am facing with this error

LOG: unexpected E= OF on client connection

which I don not have any idea about it.
Any help to solve this error would be so appreciated.

Regards, Mandana

--_000_A9344FE6ED34A04F9BF550E6EAAAA31710611947EXDB3ugkthse_-- From adrian.klaver@gmail.com Sat Sep 10 22:04:21 2011 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 70803B5DBFC for ; Sat, 10 Sep 2011 19:04:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 14960-09 for ; Sat, 10 Sep 2011 22:04:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f42.google.com (mail-pz0-f42.google.com [209.85.210.42]) by mail.postgresql.org (Postfix) with ESMTP id C4BC6B5DC43 for ; Sat, 10 Sep 2011 19:04:14 -0300 (ADT) Received: by pzk37 with SMTP id 37so6267325pzk.15 for ; Sat, 10 Sep 2011 15:04:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:cc:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; bh=EAtyjfTbl2mcz8ZkRdtVoTMRVAEuWgtuEtysfbv1bI8=; b=CUXh2BEtuV967cZHgTcso5KD2lS3TwAOPPD6f+EXCRkXeSO3u6NUn64ROIUTVKY3J6 5+Ce1/Jbd1kmxGtQ+bFqdM3J/f/bbwPfVbwxXWBrTWxgXu3hSef4YhSuM3xTy9ErW3jY 4R70VQQ9aU7wcoLwM4GvbjevTWTUIMzteezGY= Received: by 10.68.10.40 with SMTP id f8mr2379146pbb.67.1315692254423; Sat, 10 Sep 2011 15:04:14 -0700 (PDT) Received: from tucker.localnet (c-24-17-164-54.hsd1.wa.comcast.net. [24.17.164.54]) by mx.google.com with ESMTPS id x6sm30364644pba.5.2011.09.10.15.04.11 (version=SSLv3 cipher=OTHER); Sat, 10 Sep 2011 15:04:13 -0700 (PDT) From: Adrian Klaver To: pgsql-sql@postgresql.org Subject: Re: FW: Hi Date: Sat, 10 Sep 2011 15:04:09 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.32-33-generic; KDE/4.4.5; i686; ; ) Cc: Mandana Mokhtary References: In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Message-Id: <201109101504.09488.adrian.klaver@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.889 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201109/21 X-Sequence-Number: 35821 On Saturday, September 10, 2011 2:22:32 pm Mandana Mokhtary wrote: > ________________________________ > From: Mandana Mokhtary > Sent: 10 September 2011 23:21 > To: pgsql-sql-owner@postgresql.org > Subject: Hi > > Hi All > I tried to import shapfile into postgres using this comand: > > pgsql -c -s 3006 -W LATIN1 c:/...... |psql _U postgres (database name) > > I could import some but not all. > I got this error that I do not have any idea about it: > > current transaction is aborted, commands ignored until end of transactions > block. > Means just what it says, a transaction was aborted due to error and at that point all further commands where ignored. > at fisrt, the name of the shapfiles have some Swedish alphabet which i > changed it to latin > > I would appreciate any help. The actual command string would be nice:) If the above was it then that explains the problem. First I think you are looking for psql not pgsql. Second it should be psql -U postgres ... > > Regards, Mandana -- Adrian Klaver adrian.klaver@gmail.com From ringerc@ringerc.id.au Mon Sep 12 01:31:59 2011 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2FA9EB5DBE1 for ; Sun, 11 Sep 2011 22:31:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 22330-02 for ; Mon, 12 Sep 2011 01:31:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 3A2BFB5DBC5 for ; Sun, 11 Sep 2011 22:31:49 -0300 (ADT) Received: by vxi9 with SMTP id 9so2404266vxi.19 for ; Sun, 11 Sep 2011 18:31:49 -0700 (PDT) Received: by 10.52.173.230 with SMTP id bn6mr415686vdc.522.1315791109192; Sun, 11 Sep 2011 18:31:49 -0700 (PDT) Received: from [10.1.1.6] (124-148-242-247.dyn.iinet.net.au [124.148.242.247]) by mx.google.com with ESMTPS id ig8sm9419331vdb.3.2011.09.11.18.31.46 (version=SSLv3 cipher=OTHER); Sun, 11 Sep 2011 18:31:48 -0700 (PDT) Message-ID: <4E6D60F7.5080101@ringerc.id.au> Date: Mon, 12 Sep 2011 09:31:35 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 MIME-Version: 1.0 To: Mandana Mokhtary CC: "pgsql-sql@postgresql.org" Subject: Re: FW: Hi References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201109/22 X-Sequence-Number: 35822 On 11/09/2011 5:22 AM, Mandana Mokhtary wrote: > > ------------------------------------------------------------------------ > *From:* Mandana Mokhtary > *Sent:* 10 September 2011 23:21 > *To:* pgsql-sql-owner@postgresql.org > *Subject:* Hi > > Hi All > I tried to import shapfile into postgres using this comand: > > pgsql -c -s 3006 -W LATIN1 c:/...... |psql _U postgres (database name) > > I could import some but not all. > I got this error that I do not have any idea about it: > > current transaction is aborted, commands ignored until end of > transactions block. There was another error before that one, look for it. You want the FIRST error. -- Craig Ringer