| From: | Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: On the performance of views |
| Date: | 2004-01-28 08:43:55 |
| Message-ID: | 4017764B.3080903@frodo.hserus.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stef | 2004-01-28 10:11:09 | postgres timeout. |
| Previous Message | Joe Conway | 2004-01-28 00:56:18 | Re: pl/pgSQL versus pl/Python |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stef | 2004-01-28 10:11:09 | postgres timeout. |
| Previous Message | Tom Lane | 2004-01-28 07:50:01 | Re: Aggregate function error in 7.4 |