From kichi@rediffmail.com Fri Oct 21 15:24:25 2005 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AE5CEDA54D for ; Fri, 21 Oct 2005 12:24:25 -0300 (ADT) 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 07909-02 for ; Fri, 21 Oct 2005 15:24:22 +0000 (GMT) Received: from rediffmail.com (unknown [202.54.124.216]) by svr1.postgresql.org (Postfix) with SMTP id 32878D9F3E for ; Fri, 21 Oct 2005 12:24:20 -0300 (ADT) Received: (qmail 3573 invoked by uid 510); 21 Oct 2005 15:24:11 -0000 Date: 21 Oct 2005 15:24:11 -0000 Message-ID: <20051021152411.3572.qmail@webmail50.rediffmail.com> Received: from unknown (157.182.40.21) by rediffmail.com via HTTP; 21 oct 2005 15:24:11 -0000 MIME-Version: 1.0 From: "krishnaa sridharan" Reply-To: "krishnaa sridharan" To: pgsql-sql@postgresql.org Subject: SQL language Content-type: multipart/alternative; boundary="Next_1129908251---0-202.54.124.216-3565" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.44 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, HTML_50_60=0.095, HTML_IMAGE_ONLY_08=1.97, HTML_MESSAGE=0.001, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: ** X-Archive-Number: 200510/268 X-Sequence-Number: 23121 This is a multipart mime message --Next_1129908251---0-202.54.124.216-3565 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =A0=0ADear all,=0AI am a new user to PostGRE SQL. When i installed the app= lication on the windows xp machine, There were no language for the template= database created. Is there a way to add pl/sql to the databse that i creat= e. Can some one guide me on how to do this.=0AThanks=0AKrishnaa --Next_1129908251---0-202.54.124.216-3565 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0A 
=0ADear all,
=0AI am a new user to PostGRE SQL. When i = installed the application on the windows xp machine, There were no language= for the template database created. Is there a way to add pl/sql to the dat= abse that i create. Can some one guide me on how to do this.
=0AThanks=0AKrishnaa=0A

=0A

=0A=0A --Next_1129908251---0-202.54.124.216-3565-- From grzm@myrealbox.com Tue Oct 25 02:56:04 2005 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 620E7DADC9 for ; Mon, 24 Oct 2005 23:56:04 -0300 (ADT) 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 55822-02 for ; Tue, 25 Oct 2005 02:55:52 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [151.155.5.143]) by svr1.postgresql.org (Postfix) with ESMTP id 3166ADB3DD for ; Mon, 24 Oct 2005 23:49:08 -0300 (ADT) Received: from [172.16.1.100] grzm [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.6 $ on Linux via secured & encrypted transport (TLS); Mon, 24 Oct 2005 20:49:07 -0600 In-Reply-To: <20051021152411.3572.qmail@webmail50.rediffmail.com> References: <20051021152411.3572.qmail@webmail50.rediffmail.com> Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: SQL language Date: Tue, 25 Oct 2005 11:49:03 +0900 To: "krishnaa sridharan" X-Mailer: Apple Mail (2.734) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.273 required=5 tests=[AWL=0.273] X-Spam-Level: X-Archive-Number: 200510/277 X-Sequence-Number: 23130 On Oct 22, 2005, at 0:24 , krishnaa sridharan wrote: > I am a new user to PostGRE SQL. Welcome! [Please note that the it is PostgreSQL or Postgres.] > When i installed the application on the windows xp machine, There > were no language for the template database created. Is there a way > to add pl/sql to the databse that i create. Can some one guide me > on how to do this. PL/sql is available by default. You should be able to create a function without installing anything. To test, try creating a simple function such as this: test=# create function test_true() returns boolean language SQL as 'select true;'; CREATE FUNCTION test=# select test_true(); test_true ----------- t (1 row) If you want to install other procedural languages, perhaps the documentation can help. http://www.postgresql.org/docs/8.0/interactive/xplang.html#XPLANG- INSTALL Hope this helps. Michael Glaesemann grzm myrealbox com