Hi all,
I need help on creating a sql, not a problem even if its pl/sql
I have orders table schema is as follow
orders(order_id,user_id, create_timestamp, amount)
and I want to generate a report like
for the past 3 days bucketing purchases i.e SUM(amount) every day in
columns
i.e result will be
2009/6/23 Rob Sargent
>
> Not sure if this belongs here or on the admin or performance list.
> Apologies if so. (And this may be a second posting as the first was from an
> un-registered account. Further apologies)
>
> My assumption is that any de/compression done by postgres would be
> server-
On 2009-06-23, Rob Sargent wrote:
>
> Not sure if this belongs here or on the admin or performance list.
> Apologies if so. (And this may be a second posting as the first was from
> an un-registered account. Further apologies)
>
> My assumption is that any de/compression done by postgres would
In article <24680.1245784...@sss.pgh.pa.us>,
Tom Lane writes:
> Joshua Tolley writes:
>> Primary keys are NOT NULL and UNIQUE. You can't have null values in a primary
>> key.
> On reflection I think the OP's beef is that we complain about this:
> regression=# create table t (f1 int null not nu
