On Thu, 7 Feb 2002, Mike Barrett wrote:
> It inserts just fine, automatically taking the default value for
> id. However, the table I'm actually using is the reverse of the previous.
> Example:
>
> [Table name 'status']
> id | integer | not null default
> nextval('"status_id_seq"'::text)
> name | character varying(32) |
>
> sql=> insert into test values (,'blah');
insert into test (name) values ('blah');
--
Tycho Fruru tycho(dot)fruru(at)conostix(dot)com