sumit <[EMAIL PROTECTED]> writes: > In keeping with this, we first define the syntax of a CUBE statement as follows:
> SELECT <field list><aggregate list> > INTO <destination table> > FROM <table expression> > WHERE <search condition> > GROUP BY <aggregate list> > HAVING <search condition> > WITH CUBE; SQL99 defines a GROUP BY CUBE(...) operation, which seems to do the same thing as this. Why are you using a nonstandard syntax? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])