X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 8752811F677C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 Apr 2006 06:27:52 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 01781-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 Apr 2006 06:27:44 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.logix-tt.com (unknown [212.211.145.186])
	by postgresql.org (Postfix) with ESMTP id CA69F11F6770
	for <pgsql-sql@postgresql.org>; Thu,  6 Apr 2006 06:27:46 -0300 (ADT)
Received: from kingfisher.intern.logix-tt.com (T9662.t.pppool.de
	[89.55.150.98])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id 89373656C0;
	Thu,  6 Apr 2006 11:28:34 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 65CB218167709;
	Thu,  6 Apr 2006 11:28:00 +0200 (CEST)
Message-ID: <4434DF20.2070300@logix-tt.com>
Date: Thu, 06 Apr 2006 11:28:00 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Debian Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Michael Burke <michael@engtech.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: SELECT composite type
References: <200604051257.09980.michael@engtech.ca>
In-Reply-To: <200604051257.09980.michael@engtech.ca>
X-Enigmail-Version: 0.93.0.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120]
X-Spam-Score: 0.12
X-Spam-Level: 
X-Archive-Number: 200604/35
X-Sequence-Number: 24844

Hi, Michael,

Michael Burke wrote:

> This statement works, but I don't want to duplicate the function call as this 
> should be unnecessary.

Is this for aesthetic reasons (typing the query), or for speed reasons?

If the latter one is true, then check that all functions are defined as
"immutable" or, at least, "stable". Then the qery planner should flatten
them to be called only once.

Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org