Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group