Re: [GENERAL] Training and open source

2009-12-17 Thread Picavet Vincent
Hi, Would one day the Talend people understand that Astroturfing is definitly not a good marketing strategy ? Please stop your lame posting once and for all, we are all tired of reading your useless babbling. Vincent > -Message d'origine- > De : pgsql-general-ow...@postgresql.org > [mai

[GENERAL] gap in sequence numbers

2009-09-18 Thread Picavet Vincent
Hi, Please consider the following query. The reftable inner query generates a table with 11 elements, 7 of them having the groupkey 1, and the 4 others the groupkey 2. This set is then grouped by the groupkey field, and after that a generate_series and a sequence are used to create an ordered id.

Re: [GENERAL] [PGSQL 8.3.5] Use of a partial indexes

2008-12-30 Thread Picavet Vincent
Hello, Why do you index a boolean of your condition ? Isn't it better to have the partial index like the following ? : CREATE INDEX i_gm_t_movimenti_magazzini_partial ON gm_t_movimenti_magazzini( ap_prod_unic ) WHERE gm_moma_flag AND gm_moma_vali>='2008-01-01'::TIMESTAMPTZ; Hope this helps, Vi

Re: [GENERAL] Favorite Tom Lane quotes

2008-12-02 Thread Picavet Vincent
Hi, > "Never underestimate the bandwidth of a station wagon full of > tapes hurtling down the highway." -Tanenbaum, Andrew S. > (1996). Computer Networks. New Jersey: Prentice-Hall, 83. > ISBN 0-13-349945-6. > > A modern chrysler town and country(1) has a cargo capacity of > 140.1 cubic feet