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