On Fri, 15 Aug 2003 00:32:01 -0700 (PDT)
Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> 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.
Please elaborate. How is it inconsistent, exactly?
>
> 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?
Oh a test....
Does the \. end the STDIN input?
Where's the null option? Don't you mean:
copy test from stdin with delimiter ',' null '';
In this case I would expect the row to have:
a | b
----------
|
abc | 5
Is this too much to expect?
>
>
>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
