pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
SQL language 2+ messages / 2 participants [nested] [flat]
* SQL language @ 2005-10-21 15:24 krishnaa sridharan <kichi@rediffmail.com> 2005-10-25 02:49 ` Re: SQL language Michael Glaesemann <grzm@myrealbox.com> 0 siblings, 1 reply; 2+ messages in thread From: krishnaa sridharan @ 2005-10-21 15:24 UTC (permalink / raw) To: pgsql-sql Dear all, 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. Thanks Krishnaa ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: SQL language 2005-10-21 15:24 SQL language krishnaa sridharan <kichi@rediffmail.com> @ 2005-10-25 02:49 ` Michael Glaesemann <grzm@myrealbox.com> 0 siblings, 0 replies; 2+ messages in thread From: Michael Glaesemann @ 2005-10-25 02:49 UTC (permalink / raw) To: krishnaa sridharan <kichi@rediffmail.com>; +Cc: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-10-25 02:49 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-10-21 15:24 SQL language krishnaa sridharan <kichi@rediffmail.com> 2005-10-25 02:49 ` Michael Glaesemann <grzm@myrealbox.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox