Thread: create view foo as select avg(x), avg(y) from bar; "ERROR: attribute 'avg' duplicated" BUG or FEATURE?
create view foo as select avg(x), avg(y) from bar; "ERROR: attribute 'avg' duplicated" BUG or FEATURE?
From
Javier Kohen
Date:
Your name : Javier Kohen Your email address : jkohen@tough.com System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium MMX Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.0pre6 ELF PostgreSQL version (example: PostgreSQL-6.4) : PostgreSQL-6.4 Compiler used (example: gcc 2.8.0) : gcc 2.8.1 + glibc 2.0.7pre6 Please enter a FULL description of your problem: ------------------------------------------------ Doing: create view foo as select avg(x), avg(y) from bar; causes: ERROR: attribute 'avg' duplicated when select avg(x), avg(y) from bar; does not. The same happens for: create view foo as select bar.list, baz.list from bar, baz; Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- Always reproducible. If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- Adding support, I guess. I got the two examples from a book and they were supposed to work in Sybase Anywhere SQL 5.0. PS: for PostgreSQL to compile with my configuration, I had to add manualy the nan.h header somewhere in the sources, IIRCit was postgres.h or something included from (almost) everywhere, just to be sure. -- Javier Kohen <jkohen@tough.com> ICQ #3855350 [The_Crusher] http://members.xoom.com/jkohen/ http://www.geocities.com/SunsetStrip/Studio/3077/ -----BEGIN PGP PUBLIC KEY BLOCK----- Version: PGPfreeware 5.0i for non-commercial use mQGiBDZ1dZoRBADCqJiPpgkJiD5j4nORfxhGecVNTC+LtCxdUlB5/GTQEAgUntRh 94EeqWmQsEIpD4nZB179qO2WQPAU0+zRF4QUG2Nd4z98eNW8oKg6W4b6MqVXrs8Z p8MJixE95Shqt5tcytlOdtfjjHba+07MViIb1jh4WdfoNXIqCTglDtdXGwCg/8mW zNFjAMqgcUk1hwChaTCOAvsD/jBNPndppVonTLwrZJ4ftuxs4ibJ/Zqvj/Gtfc2Y 7nVNDgy75NfWcXzAbDqyUuBkEaLZyn9ffaIA/GAIAT1QXLR57lW/oSDwlf13hBx0 KlzElCW2IIkpvl2RlqCxrkTXeifZFJjtcOC9p7UrLe1f8F0cXyED0qqPQ1tX1Hwg Z9uCA/9bv9etTpf7wGhgRV0hKyGJITpwDESegSss7xncSyOcJRsfAIul5TyLaJ9f I++czsdBgcEvgQzFhAkCS1T/GEkt+W4imaHTdDlHwKKtW9wQ7Vqa+CFVIMiD9ZGR 8yaV7dCrAh8gs+3ccxb/jSIAihqtoDItK33l2itsqm6xaNnMLLQfSmF2aWVyIEtv aGVuIDxqa29oZW5AdG91Z2guY29tPokASwQQEQIACwUCNnV1mgQLAwECAAoJEGSq Zf2xzAOqE7oAn0eZyvMJe8nHNbtAtNGccqso9t+pAJ9wktpNzvKIsc9PrbF9W4nr GttxsLkCDQQ2dXWcEAgA9kJXtwh/CBdyorrWqULzBej5UxE5T7bxbrlLOCDaAadW oxTpj0BV89AHxstDqZSt90xkhkn4DIO9ZekX1KHTUPj1WV/cdlJPPT2N286Z4VeS Wc39uK50T8X8dryDxUcwYc58yWb/Ffm7/ZFexwGq01uejaClcjrUGvC/RgBYK+X0 iP1YTknbzSC0neSRBzZrM2w4DUUdD3yIsxx8Wy2O9vPJI8BD8KVbGI2Ou1WMuF04 0zT9fBdXQ6MdGGzeMyEstSr/POGxKUAYEY18hKcKctaGxAMZyAcpesqVDNmWn6vQ ClCbAkbTCD1mpF1Bn5x8vYlLIhkmuquiXsNV6TILOwACAgf+NCsvZgOoz0t6wVwo yg7LcwsJWeEaWY/Vl9zo8lF6AmGAA5ZpTV/Sndm8MR5Kw6MuooVBArUnXXhmCPbq sqFOt3QS0dt0Scqx4YjXw8JzPS0vOn42HGmf2QEtzoEtWifXV2A7iKrwN76lk236 etyUkVD6zgWKeBXX+zJ+u9Be21AtRvIuIziWGt7xofNgnK1OxtAwCOvyCEfK2WiL eY+MS33uqw/ZvcxVXyyF/XTvOnGY2IIGi0fdCmhUxD9TE/ugE+QioKdrWJVSzuwV ADVG3CCvCG2BMoBoUqze9RrWZMvjdQeOnBk0oyvLvsnAK6AZTI2YORUBETXWqFC4 TQKylokAPwMFGDZ1dZxkqmX9scwDqhEC7EwAoPS1eBdGA7Txyk7b4ChuPOODBVYT AJ4gd5QHMmrcArSkgWL+nYoZUJxJkg== =p9KG -----END PGP PUBLIC KEY BLOCK-----