Обсуждение: Create Procedure syntax
Hi,
I have 3 simple questions:
1. What is the exact syntax to create a procedure?
2. How can I print something to my screen ,e..g, the value of a variable in a stored procedure.
Something similar to DBMS_OUTPUT.PUT_LINE in Oracle??
3. Also, is there any dynamic discussion forum for PGSQL, where I post a query, and anyone can reply me back and I can see the reply immediately in the forum.
Thanks to anyone who can guide me in the right direction.
Shiva.
>>>>> "S" == Sivagami <sivagami@worlddata.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@aaanet.ru http://tolikus.hq.aaanet.ru:8080 Phone: (8632)-710071