Stored procedures
Hi,
I�m new in PostgreSQL, but i have worked with many databases systems. I
know good standard SQL language. I know that stored procedures I can create
by CREATE PROCEDURE. But I didn �t find this syntax in Postgre SQL. How is
it in Postgres? I�m using PostgreSQL 7.1.3
thanks
Tomas Kubis
A good start is the interactive documentation:
http://www.postgresql.org/idocs/ , specifically the section "Procedural
Languages".
Bruce Momjian'b book "Postgresql Introduction and concepts" gives some good
examples.
David.
Tom� Kubi� wrote in message <9s5l2q$2qbk$1@news.tht.net>...
Show quoted text
Hi,
I�m new in PostgreSQL, but i have worked with many databases systems. I
know good standard SQL language. I know that stored procedures I can create
by CREATE PROCEDURE. But I didn �t find this syntax in Postgre SQL. How is
it in Postgres? I�m using PostgreSQL 7.1.3thanks
Tomas Kubis
GET ME OFF THIS LIST !
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom� Kubi�
Sent: Monday, November 05, 2001 03:12 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Stored procedures
Hi,
I�m new in PostgreSQL, but i have worked with many databases systems. I
know good standard SQL language. I know that stored procedures I can create
by CREATE PROCEDURE. But I didn �t find this syntax in Postgre SQL. How is
it in Postgres? I�m using PostgreSQL 7.1.3
thanks
Tomas Kubis
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
PostgreSql does NOT manage stored procedure, it only can manage functions
returning single values.
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of david morgan
Sent: Monday, November 05, 2001 10:07 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Stored procedures
A good start is the interactive documentation:
http://www.postgresql.org/idocs/ , specifically the section "Procedural
Languages".
Bruce Momjian'b book "Postgresql Introduction and concepts" gives some good
examples.
David.
Tom� Kubi� wrote in message <9s5l2q$2qbk$1@news.tht.net>...
Hi,
I�m new in PostgreSQL, but i have worked with many databases systems. I
know good standard SQL language. I know that stored procedures I can create
by CREATE PROCEDURE. But I didn �t find this syntax in Postgre SQL. How is
it in Postgres? I�m using PostgreSQL 7.1.3thanks
Tomas Kubis
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
GET ME OFF THIS LIST !
There are subscribe and unsubscribe commands at the bottom of each email.
There are subscribe and unsubscribe commands sent to you with your
subscription to this mailing list.
I am glad I'm not your employer.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Like it says at the bottom of every 5-6 emails :
subscribe and unsubscribe commands go to majordomo@postgresql.org
OR
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
It's quite simple really.
On Mon, 5 Nov 2001, Eric Day wrote:
PostgreSql does NOT manage stored procedure, it only can manage functions
returning single values.-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of david morgan
Sent: Monday, November 05, 2001 10:07 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Stored proceduresA good start is the interactive documentation:
http://www.postgresql.org/idocs/ , specifically the section "Procedural
Languages".
Bruce Momjian'b book "Postgresql Introduction and concepts" gives some good
examples.David.
Tom� Kubi� wrote in message <9s5l2q$2qbk$1@news.tht.net>...
Hi,
I�m new in PostgreSQL, but i have worked with many databases systems. I
know good standard SQL language. I know that stored procedures I can create
by CREATE PROCEDURE. But I didn �t find this syntax in Postgre SQL. How is
it in Postgres? I�m using PostgreSQL 7.1.3thanks
Tomas Kubis
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
--
by way of pgsql-general@commandprompt.com
http://www.postgresql.info/
http://www.commandprompt.com/