Re: Create Procedure syntax

>>>>> "S" == Sivagami <sivagami(at)worlddata(dot)com> writes:

S> [1 <text/plain; iso-8859-1 (quoted-printable)>]
S> Hi,

S> I have 3 simple questions:

S> 1. What is the exact syntax to create a procedure?

CREATE FUNCTION name ( [ ftype [, ...] ] )
RETURNS rtype
AS definition
LANGUAGE 'langname'
[ WITH ( attribute [, ...] ) ]
CREATE FUNCTION name ( [ ftype [, ...] ] )
RETURNS rtype
AS obj_file , link_symbol
LANGUAGE 'C'
[ WITH ( attribute [, ...] ) ]

There are _no_ procedures in Postgres, functions only! This syntax is
taken from "PostgreSQL User's Guide".

S> 2. How can I print something to my screen ,e..g, the value of a
variable in a stored procedure.

You can use 'raise notice' in plpgsql functions:

---------------------------------------
Aborting and messages

As indicated in the above examples there is a RAISE statement that can throw messages into the Postgres elog
mechanism.

RAISE level format'' [, identifier [...]];

Inside the format, "%" is used as a placeholder for the subsequent comma-separated identifiers. Possible levels
are DEBUG (silently suppressed in production running databases), NOTICE (written into the database log and
forwarded to the client application) and EXCEPTION (written into the database log and aborting the transaction).
---------------------------------------

--
Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru
http://tolikus.hq.aaanet.ru:8080 Phone: (8632)-710071