Re: Select default values

Поиск
Список
Период
Сортировка
Искать
От
Giorgio Valoti
Тема
Re: Select default values
Дата
Msg-id
252ABD01-5957-48E1-AF5F-72FFC48EBD30@mac.com
Ответ на
Re: Select default values (Richard Broersma)
Список
Дерево обсуждения
Select default values Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
Re: Select default values "Pavel Stehule" <pavel.stehule@gmail.com>
Re: Select default values Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
Re: Select default values "Pavel Stehule" <pavel.stehule@gmail.com>
Re: Select default values Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
Re: Select default values "Pavel Stehule" <pavel.stehule@gmail.com>
Re: Select default values Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
Re: Select default values Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: Select default values Giorgio Valoti <giorgio_v@mac.com>
Re: Select default values Richard Huxton <dev@archonet.com>
Re: Select default values Giorgio Valoti <giorgio_v@mac.com>
Re: Select default values "Richard Broersma" <richard.broersma@gmail.com>
Re: Select default values Giorgio Valoti <giorgio_v@mac.com>
Re: Select default values "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Select default values Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
Re: Select default values "Scott Marlowe" <scott.marlowe@gmail.com> 

On 24/lug/08, at 23:15, Richard Broersma wrote:

> On Thu, Jul 24, 2008 at 12:35 PM, Giorgio Valoti  
>  wrote:
>
>>> Um - there is no default value for a function.
>>
>> Without this "feature" you have to overload
>> the function arguments.
>
> You could pass a casted null to the function.  The would eliminate
> function overloading.  Then internally you could handle the null by
> passing DEFAULTS to you INSERT or UPDATE statements.  I don't know if
> this would work for you in this case.

It could work but only if I use a domain that allows NULLs, which  
reduces the usefulness of domains even if you can work around that by  
simply stating the not null clause in the table definition.

--
Giorgio Valoti
В списке pgsql-sql по дате отправления
Предыдущее
От: Allan Kamau
Дата:
Следующее
От: TJ O'Donnell
Дата:
FAQ