Re: SELECT composite type

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: SELECT composite type
Дата
Msg-id 4434DF20.2070300@logix-tt.com
обсуждение исходный текст
Ответ на SELECT composite type  (Michael Burke <michael@engtech.ca>)
Список 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 по дате отправления:

Предыдущее
От: "AKHILESH GUPTA"
Дата:
Сообщение: pgcrypto-crypt
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: have you feel anything when you read this ?