Thread

1. UNION and VIEW

   Roland Schulz <rschulz9@web.de> — 2001-02-05T20:48:28Z

   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.

2. Re: UNION and VIEW

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-02-06T16:01:11Z

   Roland Schulz <rschulz9@web.de> writes:
   > When using UNION in a VIEW, the view displays always all records
   > disregarding any WHERE's. This problem didn't happen with beta1.
   
   Yeah, this was a silly error added in beta4.  It's fixed in the current
   snapshot.
   
   			regards, tom lane