Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>
>> I don't see any reasonable way to sandwhich the FORCE NOT NULL syntax
>> into a keyword/value notation.
>>
>
> Any number of ways, for example "force_not_null = true" or multiple
> occurrences of "force_not_null = column_name". Andrew was on the verge
> of admitting we don't need that option anymore anyway ;-), so I don't
> think we should allow it to drive an exception to the simplified syntax.
>
>
>
We won't need it if we can use an expression on the source, like
coalesce(t[4],"")
that gets applied on the way in. Until then it is useful, if ugly.
cheers
andrew