Error in parser with UNIONS.
От | Chris Albertson |
---|---|
Тема | Error in parser with UNIONS. |
Дата | |
Msg-id | 3564AD12.66C063F3@topdog.logicon.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] Error in parser with UNIONS.
|
Список | pgsql-hackers |
Got no reply on "questions". Someone here may want to know this... I think I may have uncovered an error in the parser. The following is the simplest example that shows the problem. Maybe a counter needs to be reset by 'union' or checked after select not statement. I would like to use this syntax in my libpq program. Is this a bug? Is it already known? Would someone please e-mail me the syntax for the "explicit cast" the system wants I am using 6.3.2 on an Ultra SPARC. The error occurs on a Linux RH50 Intel system too. I think the following should work but does not: testdb=> select 'a' as X testdb-> union testdb-> select 'b' as X; NOTICE: there is more than one operator < for types NOTICE: unknown and unknown. You will have to retype this query ERROR: using an explicit cast Notice that this does work testdb=> select 'b' as X; x - b (1 row) And this works too: testdb=> select 1 as X testdb-> union testdb-> select 2 as X; x - 1 2 (2 rows) -- --Chris Albertson chris@topdog.logicon.com Voice: 626-351-0089 X127 Logicon RDA, Pasadena California Fax: 626-351-0699
В списке pgsql-hackers по дате отправления: