Thread: Feature request: DEFAULT as input value of function argument

Hi, community

The case:

E.g. I need to write a function that should do updates of a table. In
the function I have to specify necessary columns I need to update as
arguments and write update of the columns with this arguments.
Everything is ok but the case when I need to skip some column in
update to use DEFAULT value of the column.

IMHO convenient solution is to make possible to specify something like
COLUMN_DEFAULT as input value of function.

I wonder if it's possible.

-- 
Regards,
Sergey Konoplev
--
PostgreSQL articles in english & russian
http://gray-hemp.blogspot.com/search/label/postgresql/

> IMHO convenient solution is to make possible to specify something like
> COLUMN_DEFAULT as input value of function.
>
> I wonder if it's possible.
>

So, what do you think of it?

-- 
Regards,
Sergey Konoplev
--
PostgreSQL articles in english & russian
http://gray-hemp.blogspot.com/search/label/postgresql/

Hello

defaults are supported in 8.4

regards
Pavel Stehule

2009/9/3 Sergey Konoplev <gray.ru@gmail.com>:
>> IMHO convenient solution is to make possible to specify something like
>> COLUMN_DEFAULT as input value of function.
>>
>> I wonder if it's possible.
>>
>
> So, what do you think of it?
>
> --
> Regards,
> Sergey Konoplev
> --
> PostgreSQL articles in english & russian
> http://gray-hemp.blogspot.com/search/label/postgresql/
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>