UNION and VIEW

Started by Roland Schulzabout 25 years ago2 messagesbugs
Jump to latest
#1Roland Schulz
rschulz9@web.de

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.

Attachments:

bug.sqltext/plain; charset=us-ascii; name=bug.sqlDownload
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Roland Schulz (#1)
Re: UNION and VIEW

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