On Thursday, February 20, 2003, at 10:20 PM, Tom Lane wrote:
> "Eric B. Ridge" <ebr(at)tcdi(dot)com> writes:
>> INSERT INTO foo (id, title, type) VALUES (<default>, 'whatever',
>> <default>);
>
>> Is there no keyword for getting the DEFAULT value of a column when
>> doing an INSERT?
>
> Not sure how far back this goes, but in 7.3 you can say DEFAULT:
<snip>
> alter table foo_view alter column id set default
> nextval('seq_foo_id');
>
> and away you go.
Thanks for this information. Y'all rock. These two things are enough
to convince me to upgrade to 7.3 immediately.
eric