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

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.