hai all,
please help me, i've made a view named bpbkain
CREATE OR REPLACE VIEW gmt.bpbkain AS
SELECT bpb.tanggal AS tgl_bukti, n.supplier, bpb.nobukti, n.no_po,
n.jenis_kain, n.gramasi, n.warna, n.lebar, n.no_inv, n.harga, n.sat_harga,
COALESCE(sum(netto2.netto), 0::double precision)::numeric
Hi!
Is there a simple way to generate sequences of dates like the following?
"2008-07-03 00:00:00"
"2008-07-04 00:00:00"
"2008-07-05 00:00:00"
"2008-07-06 00:00:00"
I'd like to join a table to aggregate the number of items for each day
(each item has a timestamp).
am Mon, dem 20.10.2008, um 15:24:38 +0200 mailte Patrick Scharrenberg
folgendes:
> Hi!
> Is there a simple way to generate sequences of dates like the following?
> "2008-07-03 00:00:00"
> "2008-07-04 00:00:00"
> "2008-07-05 00:00:00"
> "2008-07-06 00:00:00"
>
Sure:
test
Hi!
>> Is there a simple way to generate sequences of dates like the following?
> Sure:
> test=# select '2008-07-03'::date + s * '1day'::interval from
> generate_Series(1,10) s;
Thanks! Thats what I was searching for.
You saved my day from manually adding missing dates in a huge excel sheet!
S
Greetings,
I couldn't find anything about this in the documentation or the mailing list
archives, so forgive me if this has already been addressed.
I'm trying to determine if the full text indexing has any built-in
capability for providing information about word occurrence, i.e. the numbe
