David Fetter wrote: > I'd like to be able to create functions with named parameters that > could be called with the names in any order. For example, > > CREATE OR REPLACE FUNCTION foo_func(name TEXT, val INTEGER) AS ... > > SELECT foo_func(val AS 23, name AS 'Name goes here');
When that was brought up last time, I think the hard part was what syntax to use. You can't use AS because SQL uses that for something different. => might be OK, but then we'd need to disallow that as operator name. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(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
