Named function arguments

[md5]

Does Sequel support named function arguments in addition to positional arguments? I'm not sure if any databases other than PostgreSQL support them, but I think the answer from looking at the Sequel documentation and the code is "no".

Here's an example:

select now() + make_interval(days => 3);

In that particular case, I think you could use '3 days'::interval as a workaround, which Sequel does support, but that's not the case with most functions.

[jeremyevans]

There isn't generic support for named function arguments currently. For your example, the date_arithmetic extension should do what you want:

DB.select(Sequel.date_add(Sequel::CURRENT_TIMESTAMP, days: 3))
# SELECT (CAST(CURRENT_TIMESTAMP AS timestamp) + make_interval(days := 3))

[md5]

My real use case is for a custom function, so that wouldn't actually help. I just mentioned make_interval because it's a well-known function that is typically called with named arguments.

It also looks like PostgreSQL doesn't support any way of passing the default value for a positional argument explicitly, so in addition to needing to know the parameter order to call a function without using named arguments, you also need to explicitly restate the defaults for any non-trailing arguments.