I know nested aggregates aren't allowed, or at least not implicitly.
Is there a way to get around this.?
Or does someone feel like droppng some other hints this way?
Problem : (not really)
I have a table (id, date, ordertype, etc...)
Based on the type i want to be able to get the counts of how
>From: Carolyn Lu Wong <[EMAIL PROTECTED]>
>To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>Subject: [SQL] primary key question
>Date: Thu, 20 Jul 2000 17:26:30 +1000
>
>create table aaa(
> field1 not null,
> field2 ,
> ,
> primary key (field1, field2)
>);
>
This is a test to see if I can post. Seems my last post didn't go
through...
Carolyn Lu Wong wrote:
>
> I have a field in a table that has been defined 'not null'. Is it
> possible to remove this constraint? I don't see this option under 'alter
> table'.
update pg_attribute set attnotnull = 'f' where oid = oidofnotnullcolumn;
vacuum analyze;
Regards
Wim
Carolyn Lu Wong wrote:
>
> create table aaa(
> field1 not null,
> field2 ,
> ,
> primary key (field1, field2)
> );
>
> Based on the above table definition, field2 allows null values. But
> after the table created based on the above script, field2 be
create table aaa(
field1 not null,
field2 ,
,
primary key (field1, field2)
);
Based on the above table definition, field2 allows null values. But
after the table created based on the above script, field2 becomes not
null. The only conclusion I come u
