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-----