Specify parameter when assigning value in PostgreSQL function

Question

I have a requirement like: Call a function with 2 parameters in different situations.

function => getSum(a, b)

here it can be like,

a and b are uuid, and a and b are treated separately in the function.

Is it possible to specify a value to the parameter?

Laurenz Albe · Accepted Answer · 2019-03-05 13:40:50Z

1

For that you would use default values:

CREATE FUNCTION getsum(
   a uuid DEFAULT '...',
   b uuid DEFAULT '...'
) RETURNS ...

You can call the function like this:

SELECT getsum(b => '...');

Then the default value will be used for a.

answered Mar 5, 2019 at 13:40

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you for the answer, i will try this.