Postgres User wrote:
>>> I'm trying to write an INSERT INTO statement that will use a DEFAULT
>>> value when an input parameter is null.
>>>
>> Neither of my 2 methods are pretty.
>> 1) Use a trigger.
>> 2) Grab and cast the default value from the information_schema.columns
>> view and plug it in.
>>
>> Another option is to build your insert sql as a string and then execute it.
>>
>
> Thanks... those approaches came to mind. But I need something more
> flexible as the Insert functions are generated by an ORM layer. It
> has to be simpler.
You're not going to get anything simpler than building a string and
calling execute. Nor more flexible, come to think of it.
BTW - surely the ORM should be generating your defaults for you?
--
Richard Huxton
Archonet Ltd