Обсуждение: 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>... >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 > >
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.3 > >thanks > >Tomas Kubis > > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
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 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.3 > > > >thanks > > > >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/
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.
> 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
> 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.