is it possible to use a parameter of a plpgsql-function to order a selection
inside the function?
You need to use the FOR-IN-EXECUTE style of query. That way you can use any string you want (including text passed in as a parameter) to build the query inside the function ...
http://www.postgresql.org/docs/7.4/static/plpgsql-control-structures.html ( it is the very last thing on that page )
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
---------------------------(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
