Sorry i forgot to mention: -that you need pg 7.3 for the set-returning function feature.
-how to select from the function: select * from _YOUR_FUNCTION(PARAMETER); and NOT: select _YOUR_FUNCTION(PARAMETER); >-----Ursprüngliche Nachricht----- >Von: [EMAIL PROTECTED] [mailto:pgsql-general- >[EMAIL PROTECTED] Im Auftrag von sferriol >Gesendet: Dienstag, 24. Februar 2004 17:30 >An: [EMAIL PROTECTED] >Betreff: [GENERAL] dynamic views > >hello >is it possible with postgres 7.2 or more, to define a dynamic view. >For example, i have a table with a column 'user' >and i want to define a view which gives infomrations from different >tables but the user has to specifie the 'user' parameter when using a >select to the view > >sylvain > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
