X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 39D1FD1D3F6
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 28 Jan 2004 08:44:18 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 78441-03
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 28 Jan 2004 04:43:48 -0400 (AST)
Received: from frodo.hserus.net (frodo.hserus.net [204.74.68.40])
	by svr1.postgresql.org (Postfix) with ESMTP id 75FD5D1C4C2
	for <pgsql-performance@postgresql.org>;
	Wed, 28 Jan 2004 04:43:46 -0400 (AST)
Received: from concord.pspl.co.in ([202.54.11.72]:62570 helo=frodo.hserus.net)
	by frodo.hserus.net with asmtp
	(Cipher TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.30 #0)
	id 1AllIZ-000NYP-B8 by authid <shridhar> with plain
	for <pgsql-performance@postgresql.org>; Wed, 28 Jan 2004 14:13:47 +0530
Message-ID: <4017764B.3080903@frodo.hserus.net>
Date: Wed, 28 Jan 2004 14:13:55 +0530
From: Shridhar Daithankar <shridhar@frodo.hserus.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.6b) Gecko/20031205 Thunderbird/0.4
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: On the performance of views
References: <40152FF2.8000007@potentialtech.com>
	<4015326A.8000706@frodo.hserus.net>
	<4016BE69.9050909@potentialtech.com>
	<200401271207.33551.josh@agliodbs.com>
In-Reply-To: <200401271207.33551.josh@agliodbs.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/289
X-Sequence-Number: 5463

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