UNION and VIEW

From: Roland Schulz <rschulz9(at)web(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: UNION and VIEW
Date: 2001-02-05 20:48:28
Message-ID: 3A7F119C.E5D268F4@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Your name : Roland Schulz
Your email address : rschulz9(at)web(dot)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.

Attachment Content-Type Size
bug.sql text/plain 527 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-02-05 20:56:08 Large data field causes a backend crash.
Previous Message Tom Lane 2001-02-05 17:00:38 Re: postmaster grows