X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 9CF98D1B4E6
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 20 Oct 2003 02:58:08 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 20102-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 19 Oct 2003 23:57:41 -0300 (ADT)
Received: from web14916.mail.yahoo.com (web14916.mail.yahoo.com
	[216.136.225.229])
	by svr1.postgresql.org (Postfix) with SMTP id 21AAFD1B4E4
	for <pgsql-sql@postgresql.org>; Sun, 19 Oct 2003 23:57:37 -0300 (ADT)
Message-ID: <20031020025741.43074.qmail@web14916.mail.yahoo.com>
Received: from [202.9.168.185] by web14916.mail.yahoo.com via HTTP;
	Sun, 19 Oct 2003 19:57:41 PDT
Date: Sun, 19 Oct 2003 19:57:41 -0700 (PDT)
From: "George A.J" <jinujosein@yahoo.com>
Subject: Which is faster SQL or PL/PGSQL
To: pgsql-sql@postgresql.org
In-Reply-To: <E1A2Mum-0005F0-1f@noon.pghoster.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1629206070-1066618661=:42271"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_10_20,
	IN_REP_TO
X-Spam-Level: 
X-Archive-Number: 200310/221
X-Sequence-Number: 15621

--0-1629206070-1066618661=:42271
Content-Type: text/plain; charset=us-ascii


hi,

i am converting an MSSQL database to Postgres. there is a lot of procedures to convert.

which language is best for functions, SQL or plpgsql. 

which is faster . i am using postgres 7.3.2

jinujose


---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
--0-1629206070-1066618661=:42271
Content-Type: text/html; charset=us-ascii

<P>hi,</P>
<P>i am converting&nbsp;an MSSQL database to Postgres. there is a lot of procedures to convert.</P>
<P>which language is best for functions, SQL or plpgsql. </P>
<P>which is faster . i am using postgres 7.3.2</P>
<P>jinujose</P><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail">The New Yahoo! Shopping</a> - with improved product search
--0-1629206070-1066618661=:42271--