On Thu, 14 Aug 2003, expect wrote:
> On Thu, 14 Aug 2003 12:46:07 -0500
> Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> > Note that it isn't obvious what empty strings should map to for numbers.
> > NULL and 0 make about as much sense as using the default value.
>
> Well I'm new here but it seems to me they should map to the default value
> for that column. Why wouldn't they?
One problem with doing that is that it's inconsistent.
Given
create table test(
a text default 'abc',
b int default 5
);
copy test from stdin with delimiter ',';
,
\.
What would you expect the values of the row in test
to be?
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
