sql command strange behaviour

From: Guy Deleeuw <G(dot)De_Leeuw(at)eurofer(dot)be>
To: pgsql-admin(at)postgresql(dot)org
Subject: sql command strange behaviour
Date: 2008-10-06 08:32:06
Message-ID: 48E9CD06.4030307@eurofer.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello the list

I have a problem with an sql command and I not understand what is happens.
I execute this query and the result is ok :

db_stats=# SELECT code, label, typecumul FROM table_f801_cat_period
INNER JOIN table_cat_period USING (code) WHERE typecumul = 0 EXCEPT
SELECT code_base, label, typecumul FROM (SELECT code_base FROM
table_cat_period_tcodes INNER JOIN table_f801_cat_period ON
(code_cumul=code)) AS orphan_f801 INNER JOIN table_cat_period ON
(code_base=code) ORDER BY code;
code | label | typecumul
----------+----------+-----------
20080799 | Jul 2008 | 0
(1 ligne)

db_stats=#

Now I execute this query that request one column more, the "ind" field.,
the return of this query is bad.

db_stats=# SELECT code, label, typecumul, ind FROM table_f801_cat_period
INNER JOIN table_cat_period USING (code) WHERE typecumul = 0 EXCEPT
SELECT code_base, label, typecumul, ind FROM (SELECT code_base, ind FROM
table_cat_period_tcodes INNER JOIN table_f801_cat_period ON
(code_cumul=code) AND (ind=ind)) AS orphan_f801 INNER JOIN
table_cat_period ON (code_base=code) ORDER BY ind, code;
code | label | typecumul | ind
----------+----------+-----------+-----
20040199 | Jan 2004 | 0 | 0
20040299 | Feb 2004 | 0 | 1
20040399 | Mar 2004 | 0 | 2
20040499 | Apr 2004 | 0 | 4
20040599 | May 2004 | 0 | 5
20040699 | Jun 2004 | 0 | 6
20040799 | Jul 2004 | 0 | 9
20040899 | Aug 2004 | 0 | 10
20040999 | Sep 2004 | 0 | 11
20041099 | Oct 2004 | 0 | 13
20041199 | Nov 2004 | 0 | 14
20041299 | Dec 2004 | 0 | 15
20050199 | Jan 2005 | 0 | 19
20050299 | Feb 2005 | 0 | 20
20050399 | Mar 2005 | 0 | 21
20050499 | Apr 2005 | 0 | 23
20050599 | May 2005 | 0 | 24
20050699 | Jun 2005 | 0 | 25
20050799 | Jul 2005 | 0 | 28
20050899 | Aug 2005 | 0 | 29
20050999 | Sep 2005 | 0 | 30
20051099 | Oct 2005 | 0 | 32
20051199 | Nov 2005 | 0 | 33
20051299 | Dec 2005 | 0 | 34
20060199 | Jan 2006 | 0 | 38
20060299 | Feb 2006 | 0 | 39
20060399 | Mar 2006 | 0 | 40
20060499 | Apr 2006 | 0 | 42
20060599 | May 2006 | 0 | 43
20060699 | Jun 2006 | 0 | 44
20060799 | Jul 2006 | 0 | 47
20060899 | Aug 2006 | 0 | 48
20060999 | Sep 2006 | 0 | 49
20061099 | Oct 2006 | 0 | 51
20061199 | Nov 2006 | 0 | 52
20061299 | Dec 2006 | 0 | 53
20070199 | Jan 2007 | 0 | 57
20070299 | Feb 2007 | 0 | 58
20070399 | Mar 2007 | 0 | 59
20070499 | Apr 2007 | 0 | 61
20070599 | May 2007 | 0 | 62
20070699 | Jun 2007 | 0 | 63
20070799 | Jul 2007 | 0 | 66
20070899 | Aug 2007 | 0 | 67
20070999 | Sep 2007 | 0 | 68
20071099 | Oct 2007 | 0 | 70
20071199 | Nov 2007 | 0 | 71
20071299 | Dec 2007 | 0 | 72
20080199 | Jan 2008 | 0 | 76
20080299 | Feb 2008 | 0 | 77
20080399 | Mar 2008 | 0 | 78
20080499 | Apr 2008 | 0 | 80
20080599 | May 2008 | 0 | 81
20080699 | Jun 2008 | 0 | 82
20080799 | Jul 2008 | 0 | 85
(55 lignes)

db_stats=#

if anyone have an idea ...

Thanks in advance

Guy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Domiciano 2008-10-06 11:52:59 Shared_buffers hint
Previous Message IJS/System - Joko 2008-10-06 08:17:26 Re: logging