Skip site navigation (1) Skip section navigation (2)

Re: On the performance of views

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 (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-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

In response to

Responses

pgsql-performance by date

Next:From: StefDate: 2004-01-28 10:11:09
Subject: postgres timeout.
Previous:From: Joe ConwayDate: 2004-01-28 00:56:18
Subject: Re: pl/pgSQL versus pl/Python

pgsql-sql by date

Next:From: StefDate: 2004-01-28 10:11:09
Subject: postgres timeout.
Previous:From: Tom LaneDate: 2004-01-28 07:50:01
Subject: Re: Aggregate function error in 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group