Postgres Pro
Downloads
Home   >   mailing lists

Re: Newbie questions, diff between functions and procedures; & why cube functions? - Mailing list pgadmin-support

From Thomas Pundt
Subject Re: Newbie questions, diff between functions and procedures; & why cube functions?
Date
Msg-id 200611230857.06853.mlists@rp-online.de
Whole thread Raw
In response to Newbie questions, diff between functions and procedures; & why cube functions?  (novnov <novnovice@gmail.com>)
Responses Re: Newbie questions, diff between functions and  (novnov <novnovice@gmail.com>)
List pgadmin-support
Tree view 
Hi,

On Thursday 23 November 2006 02:21, novnov wrote:
| pgAdmin III is quite a nice tool but one thing I can't figure out is what
| the difference is between what pgAdmin calls a function and what it calls a
| procedure.

As of PostgreSQL-8.1 function arguments can be declared IN (default), OUT or
INOUT (cf. "CREATE FUNCTION"). If I understand it right, pgAdmin puts a 
function into its "Procedures" section, if it has at least one OUT parameter.

Ciao,
Thomas

-- 
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----

pgadmin-support by date:

Previous
From: Christian Eva
Date:
Subject: Compile Error with 1.6+ on SuSE 10.0/10.1 : xmlerror.h:820: error:typedef ‘xmlGenericErrorFunc’ is initialized (use__typeof__ instead)
Next
From: Kevin Field
Date:
Subject: backup/restore gone in 1.6.0?