UNION and VIEW
Roland Schulz <rschulz9@web.de>
From: Roland Schulz <rschulz9@web.de>
To: pgsql-bugs@postgresql.org
Date: 2001-02-05T20:48:28Z
Lists: pgsql-bugs
Attachments
- bug.sql (text/plain)
Your name : Roland Schulz Your email address : rschulz9@web.de System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium MMX Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.1 ELF PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1beta4 Compiler used (example: gcc 2.8.0) : 2.95.2 Please enter a FULL description of your problem: ------------------------------------------------ When using UNION in a VIEW, the view displays always all records disregarding any WHERE's. This problem didn't happen with beta1. The SELECT in the example should only display the records where the field 'typ' is 1 not all records.