Feature request: DEFAULT as input value of function argument

Started by Sergey Konoplevover 16 years ago3 messages
#1Sergey Konoplev
gray.ru@gmail.com

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/

#2Sergey Konoplev
gray.ru@gmail.com
In reply to: Sergey Konoplev (#1)
Re: Feature request: DEFAULT as input value of function argument

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/

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Sergey Konoplev (#2)
Re: Feature request: DEFAULT as input value of function argument

Hello

defaults are supported in 8.4

regards
Pavel Stehule

2009/9/3 Sergey Konoplev <gray.ru@gmail.com>:

Show quoted text

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