| 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 |
| 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 |