Thread: SQL language

<p>   <br /> Dear all,<br /> I 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 databse that i
create.Can some one guide me on how to do this.<br /> Thanks<br /> Krishnaa <br /><br /><a
href="http://adworks.rediff.com/cgi-bin/AdWorks/sigclick.cgi/www.rediff.com/signature-home.htm/1507191490@Middle5?PARTNER=3"><img
border="0"hspace="0"
src="http://adworks.rediff.com/cgi-bin/AdWorks/sigimpress.cgi/www.rediff.com/signature-home.htm/1963059423@Middle5?OAS_query=null&PARTNER=3"
vspace="0"/></a> 

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