On Fri, 15 Aug 2003 11:32:20 -0400 Murthy Kambhampaty <[EMAIL PROTECTED]> wrote:
> On Friday, August 15, 2003 03:53, expect [mailto:[EMAIL PROTECTED] wrote: > >On Fri, 15 Aug 2003 00:32:01 -0700 (PDT) > >Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > ... > >> 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? > > > > > ... > >In this case I would expect the row to have: > > > > a | b > >---------- > > | > > abc | 5 > > > > > >Is this too much to expect? > > Your expectations don't seem consistent with the table definition, which > permits Null values are allowed in (it's ironic you would add "null ''" to > the copy statement, which says you want to treat empty strings as default > values, not null!). > Why is it ironic? I don't think you've followed the thread correctly. It's what I wanted to have happen. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
