tag:blogger.com,1999:blog-8839574367290288724.post7003122615499482348..comments2023-12-11T13:13:11.330-08:00Comments on Pavel Stehule's blog: default parameters for PL functionsPavel Stěhulehttp://www.blogger.com/profile/01996484227228696817noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8839574367290288724.post-14456114911907375092008-08-27T13:13:00.000-07:002008-08-27T13:13:00.000-07:00Great feature!!!Thanks a lot, I hope this patch wi...Great feature!!!<BR/>Thanks a lot, I hope this patch will be commited.Taras Kopetshttps://www.blogger.com/profile/12855586248375499348noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-69850264666342299532008-08-27T07:41:00.000-07:002008-08-27T07:41:00.000-07:00There are named parameters and named parameters. F...There are named parameters and named parameters. First, you can use it when you create function - it is in your sample (and postgres supports it). Second - you can use names when you call function - this feature isn't supported yet. <BR/><BR/>example:<BR/>select increment( i => 10 );Pavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-85288255937262349562008-08-27T07:30:00.000-07:002008-08-27T07:30:00.000-07:00I thought PL functions already have named paramete...I thought PL functions already have named parameters, as the parameter "i" in this example from the docs:<BR/><BR/>CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS $$<BR/> BEGIN<BR/> RETURN i + 1;<BR/> END;<BR/>$$ LANGUAGE plpgsql;<BR/><BR/>I take it you mean something different?Jonathan Ellishttps://www.blogger.com/profile/11003648392946638242noreply@blogger.com