Thanks Stephan. That appears to be the reason for the differences.-ThusithaStephan Szabo <[EMAIL PROTECTED]> wrote: On Wed, 19 Apr 2006, Thusitha Kodikara wrote:> Hi,>> I observed the following on PostgreSQL 8.1.3 (on Windows 2000).>> (1) alter table invoice add column active boolean default true;>
On Wed, 19 Apr 2006, Thusitha Kodikara wrote:
> Hi,
>
> I observed the following on PostgreSQL 8.1.3 (on Windows 2000).
>
> (1) alter table invoice add column active boolean default true;
>
> This will add a new column "active" with a default clause as "true" and
> also sets the value "true" to al
Hi,
I observed the following on PostgreSQL 8.1.3 (on Windows 2000).
(1) alter table invoice add column active boolean default true;
This will add a new column "active" with a default clause as "true" and also
sets the value "true" to all existing rows of the table.
BUT
(2) ALTER TABLE invoice
