Stored procedures

Started by Tom� Kubi�over 24 years ago7 messagesgeneral
Jump to latest
#1Tom� Kubi�
kubis@vosji.cz

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

#2david morgan
david_morgan@s4c.co.uk
In reply to: Tom� Kubi� (#1)
Re: 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>...

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.3

thanks

Tomas Kubis

#3Eric Day
eday@sandibooks.com
In reply to: Tom� Kubi� (#1)
Re: Stored procedures

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

#4Eric Day
eday@sandibooks.com
In reply to: david morgan (#2)
Re: Stored procedures

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

#5speedboy
speedboy@nomicrosoft.org
In reply to: Eric Day (#3)
Re: Stored procedures

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

#6Chris
csmith@squiz.net
In reply to: Eric Day (#3)
Re: Stored procedures

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.

#7Command Prompt, Inc.
pgsql-general@commandprompt.com
In reply to: Eric Day (#4)
Re: Stored procedures

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/