pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsql command strange behaviour
2+ messages / 2 participants
[nested] [flat]
* sql command strange behaviour
@ 2008-10-06 08:32 Guy Deleeuw <G.De_Leeuw@eurofer.be>
2008-10-06 14:12 ` Re: sql command strange behaviour Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Guy Deleeuw @ 2008-10-06 08:32 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: sql command strange behaviour
2008-10-06 08:32 sql command strange behaviour Guy Deleeuw <G.De_Leeuw@eurofer.be>
@ 2008-10-06 14:12 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2008-10-06 14:12 UTC (permalink / raw)
To: Guy Deleeuw <G.De_Leeuw@eurofer.be>; +Cc: pgsql-admin
Guy Deleeuw <G.De_Leeuw@eurofer.be> writes:
> Now I execute this query that request one column more, the "ind" field.,
> the return of this query is bad.
You didn't say what you think is bad about it ... but in any case I'll
bet that this bit isn't doing what you want:
... AND (ind=ind) ...
As-is it's useless. You probably need to table-qualify one or both
names.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-10-06 14:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-06 08:32 sql command strange behaviour Guy Deleeuw <G.De_Leeuw@eurofer.be>
2008-10-06 14:12 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox