Misleading Error Message
От | Kristofer Munn |
---|---|
Тема | Misleading Error Message |
Дата | |
Msg-id | Pine.LNX.4.04.9905160009330.31033-100000@dec.munn.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] Misleading Error Message
Re: [HACKERS] Misleading Error Message |
Список | pgsql-hackers |
Hi all. Was working tonight and ran into the following error. Doing a union between two selects (to get around the lack of outer joins - hint hint), I was getting the error: ERROR: Each UNION clause must have the same number of columns Upon examining the SQL statement in question, I verified that it did, indeed, have the same number of columns. After some fiddling, I found the actual problem was that I was doing an ORDER BY on a column which was not being included in the two select statements. Unfortunately, the error message wasn't pointing at that. I'm not sure if this is just a simple change or implies other problems with the parser but I thought I'd toss it out onto the pile. Cya... - K Kristofer Munn * http://www.munn.com/~kmunn/ * ICQ# 352499 * AIM: KrMunn
В списке pgsql-hackers по дате отправления: