[SQL] Stored Procedures

2003-12-28 Thread beyaRecords - The home Urban music
Hi,
I am new to this list and the world of postgreSQL, and would like to 
know how create stored procedures in postgreSQL.

regards

Uzo

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match


Re: [SQL] Stored Procedures

2003-12-28 Thread Michael Fuhr
On Mon, Dec 29, 2003 at 01:57:00AM +, beyaRecords - The home Urban music wrote:
>
> I am new to this list and the world of postgreSQL, and would like to 
> know how create stored procedures in postgreSQL.

If you're new to PostgreSQL then have a look at the documentation:

http://www.postgresql.org/docs/

To learn about stored procedures, see the "Server Programming" part,
especially the "Extending SQL" and "PL/pgSQL - SQL Procedural Language"
chapters:

http://www.postgresql.org/docs/current/static/server-programming.html
http://www.postgresql.org/docs/current/static/extend.html
http://www.postgresql.org/docs/current/static/plpgsql.html

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [SQL] Stored Procedures

2003-12-28 Thread Christopher Browne
[EMAIL PROTECTED] (beyaRecords - The home Urban music) wrote:
> I am new to this list and the world of postgreSQL, and would like to
> know how create stored procedures in postgreSQL.

Have you considered looking at the documentation?  

It is fairly well documented there.

% man "CREATE FUNCTION" 

is quite likely to provide you with the documentation you require.
-- 
If this was helpful,  rate me
http://www3.sympatico.ca/cbbrowne/postgresql.html
"We have no need   to punish Pascal programmers.  Pascal  programming,
like chastity, is its own punishment.  The only way I could imagine to
make their wretched  state any worse would  be to make them  use Ada."
-- Scott Fahlman

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html