Re: [ADMIN] sql command strange behaviour

2008-10-06 Thread Tom Lane
Guy Deleeuw <[EMAIL PROTECTED]> 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) ...

[ADMIN] sql command strange behaviour

2008-10-06 Thread Guy Deleeuw
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,