Re: SELECT composite type - Mailing list pgsql-sql

From Markus Schaber
Subject Re: SELECT composite type
Date
Msg-id 4434DF20.2070300@logix-tt.com
Whole thread Raw
In response to SELECT composite type  (Michael Burke <michael@engtech.ca>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "AKHILESH GUPTA"
Date:
Subject: pgcrypto-crypt
Next
From: Stephan Szabo
Date:
Subject: Re: have you feel anything when you read this ?