Itagaki Takahiro wrote:
Jaime Casanova <jcasa...@systemguards.com.ec> wrote:
i can find value for FORCE QUOTE * but what's
the use case for FORCE NOT NULL?
Oh, sorry. I misread your mail.
The patch adds * options "FORCE QUOTE" and "FORCE NOT NULL", too.
Both of * mean all-columns for each options.
I still don't understand the use case for FORCE NOT NULL *.
FORCE QUOTE * is relatively benign. In particular, it doesn't affect the
null-preserving properties of our CSV implementation, since it still
won't (or shouldn't) quote null values.
FORCE NOT NULL is in any case a fairly blunt instrument - it doesn't
work for a column of any type that doesn't accept an empty string as
valid input, such as numeric types.
I note that this patch was (I think) originally submitted without prior
discussion. That's not following best practice.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
