Re: Newbie questions, diff between functions and procedures; & why cube functions?

From: Thomas Pundt <mlists(at)rp-online(dot)de>
To: pgadmin-support(at)postgresql(dot)org, novnov <novnovice(at)gmail(dot)com>
Subject: Re: Newbie questions, diff between functions and procedures; & why cube functions?
Date: 2006-11-23 07:57:06
Message-ID: 200611230857.06853.mlists@rp-online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-11-23 08:17:33 Re: Crash when cancelling filter and view data
Previous Message Christian Eva 2006-11-23 05:13:20 Compile Error with 1.6+ on SuSE 10.0/10.1 : xmlerror.h:820: error: typedef ‘xmlGenericErrorFunc’ is initialized (use __typeof__ instead)