Re: On the performance of views

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: On the performance of views
Дата
Msg-id 4017764B.3080903@frodo.hserus.net
обсуждение исходный текст
Ответ на Re: On the performance of views  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: On the performance of views  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-performance
Josh Berkus wrote:

> Bill,
>
>
>>Some functions they prototyped in MSSQL even return different types, based
>>on certian parameters, I'm not sure how I'll do this in Postgres, but I'll
>>have to figure something out.
>
>
> We support that as of 7.4.1 to an extent; check out "Polymorphic Functions".

To my understanding, polymorphism means more than one function with same name
but different signature(Sorry C++ days!!).

That still can not return rwos of two types in one call. At any moment, rowset
returned by a function call would be homogenous.

Is MSSQL allows to mix rows of two types in single function invocation, I am
sure that would be a hell lot of porting trouble..

Just a thought..

  Shridhar

В списке pgsql-performance по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: pl/pgSQL versus pl/Python
Следующее
От: Bill Moran
Дата:
Сообщение: Re: On the performance of views