Re: Passing input to a view?

am Thu, dem 10.05.2007, um 14:03:53 +0800 mailte Paul Lambert folgendes:
> Is it possible to define a view to use input parameters rather than a
> hard-wired value in a where clause?

As far as i know, no.

> Instead of having it set to 1-Jan-2007 and 10-May-2007 for the dates,
> can I specify that those values should be passed to the view? Or would I
> need to change this to an SQL language function?
>
> I can't find anything in the documentation that answers this, but maybe
> I'm not looking hard enough.

You can write a so called 'set returning function' instead.
Read more:
http://www.postgresql.org/docs/current/static/xfunc-sql.html#XFUNC-SQL-TABLE-FUNCTIONS

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net