X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8215F564EF for ; Tue, 15 Mar 2005 14:53:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62778-06 for ; Tue, 15 Mar 2005 14:53:07 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4E4CC564D1 for ; Tue, 15 Mar 2005 14:53:04 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2FEr230006074; Tue, 15 Mar 2005 09:53:02 -0500 (EST) To: "Tambet Matiisen" Cc: pgsql-sql@postgresql.org Subject: Re: Parameterized views proposition In-reply-to: References: Comments: In-reply-to "Tambet Matiisen" message dated "Tue, 15 Mar 2005 11:33:33 +0200" Date: Tue, 15 Mar 2005 09:53:01 -0500 Message-ID: <6073.1110898381@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.111 tagged_above=0 required=5 tests=AWL, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200503/223 X-Sequence-Number: 20702 "Tambet Matiisen" writes: > How tough it would be to implement > CREATE VIEW xxx PARAMETERS (yyy) AS zzz; > as > CREATE TYPE xxx; > CREATE FUNCTION xxx(yyy) RETURNING SETOF xxx LANGUAGE sql AS 'zzz'; What's the point? It'd be nonstandard anyway, so just use the function. regards, tom lane