Re: PL/pgSQL examples NOT involving functions

From: "Aasmund Midttun Godal" <postgresql(at)envisity(dot)com>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PL/pgSQL examples NOT involving functions
Date: 2001-11-27 19:59:17
Message-ID: 20011127195917.10530.qmail@213-145-170-138.dd.nextgentel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-sql

Erm, sorry about the multiple postings, I just discovered a couple of interesting tidbits after I posted first...

http://www.postgresql.org/idocs/index.php?plpgsql.html :

"The PL/pgSQL call handler parses the function's source text and produces an internal binary instruction tree the first time the function is called."

On Mon, 26 Nov 2001 17:23:13 -0800, "Josh Berkus" <josh(at)agliodbs(dot)com> wrote:
> Aasmund,
>
>
> This is incorrect. This happens with views, but not with functions.
>
> -Josh
>
>
> ______AGLIO DATABASE SOLUTIONS___________________________
> Josh Berkus
> Complete information technology josh(at)agliodbs(dot)com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

Aasmund Midttun Godal

aasmund(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Josh Berkus 2001-11-28 00:01:36 Re: PL/pgSQL examples NOT involving functions
Previous Message Aasmund Midttun Godal 2001-11-27 19:55:17 Re: PL/pgSQL examples NOT involving functions

Browse pgsql-sql by date

  From Date Subject
Next Message Glenn MacGregor 2001-11-27 22:23:25 Complex query help please
Previous Message Aasmund Midttun Godal 2001-11-27 19:55:17 Re: PL/pgSQL examples NOT involving functions