| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Michael Burke <michael(at)engtech(dot)ca> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: SELECT composite type |
| Date: | 2006-04-06 09:28:00 |
| Message-ID: | 4434DF20.2070300@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2006-04-06 11:52:55 | Re: have you feel anything when you read this ? |
| Previous Message | chris smith | 2006-04-06 08:53:17 | Re: pgcrypto-crypt |