Postgres Pro
Downloads
Home   >   mailing lists

Re: Parameterized views proposition - Mailing list pgsql-sql

From Tom Lane
Subject Re: Parameterized views proposition
Date
Msg-id 6073.1110898381@sss.pgh.pa.us
Whole thread Raw
In response to Re: Parameterized views proposition  ("Tambet Matiisen" <t.matiisen@aprote.ee>)
List pgsql-sql
Tree view 
"Tambet Matiisen" <t.matiisen@aprote.ee> 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

pgsql-sql by date:

Previous
From: PFC
Date:
Subject: Re: select multiple immediate values, but in multiple rows
Next
From: "Graham Vickrage"
Date:
Subject: Scheme not dropping