Re: how do i insert a default value?
Re: how do i insert a default value?
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"scott.marlowe" writes:
> On Tue, 12 Nov 2002, Andy Kriger wrote:
>> How do you insert a default value in an insert statement that doesn't
>> specify column names? For example, I have a table with 20 columns. I don't
>> want to specify the names in order to skip columns that have default values.
> Postgresql uses the keyword DEFAULT with no ticks to get a default.
> insert into table bubba values ('truck','washer',DEFAULT,'gun
> rack',DEFAULT,36,24,36);
That's new in 7.3, though. In prior releases you could only (a) omit
columns at the right, or (b) use a column name list.
regards, tom lane
how do i insert a default value?
От:
"Andy Kriger" <akriger@greaterthanone.com>
Дата:
How do you insert a default value in an insert statement that doesn't specify column names? For example, I have a table with 20 columns. I don't want to specify the names in order to skip columns that have default values. In MySql a null or empty value uses the default column value. In Postgres? thx andy
Re: how do i insert a default value?
От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
On Tue, 12 Nov 2002, Andy Kriger wrote:
> How do you insert a default value in an insert statement that doesn't
> specify column names? For example, I have a table with 20 columns. I don't
> want to specify the names in order to skip columns that have default values.
>
> In MySql a null or empty value uses the default column value. In Postgres?
Postgresql uses the keyword DEFAULT with no ticks to get a default.
insert into table bubba values ('truck','washer',DEFAULT,'gun
rack',DEFAULT,36,24,36);
Re: how do i insert a default value?
От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
On Tue, 12 Nov 2002, Tom Lane wrote:
> "scott.marlowe" writes:
> > On Tue, 12 Nov 2002, Andy Kriger wrote:
> >> How do you insert a default value in an insert statement that doesn't
> >> specify column names? For example, I have a table with 20 columns. I don't
> >> want to specify the names in order to skip columns that have default values.
>
> > Postgresql uses the keyword DEFAULT with no ticks to get a default.
>
> > insert into table bubba values ('truck','washer',DEFAULT,'gun
> > rack',DEFAULT,36,24,36);
>
> That's new in 7.3, though. In prior releases you could only (a) omit
> columns at the right, or (b) use a column name list.
Yeah, I realized that RIGHT after I'd written my second response. sigh
