Re: Rules and Views - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Rules and Views
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA48879A6@m0114.s-mxs.net
Whole thread Raw
In response to Rules and Views  (Curt Sampson <cjs@cynic.net>)
Responses Re: Rules and Views  (Curt Sampson <cjs@cynic.net>)
List pgsql-hackers
> But the message I was replying to was a similar union query, and I was
> thinking that that person might be having a similar initial intuitive
> reaction, "well, it looks kinda the same." I just wanted to note that
> you need to check this stuff with explain, rather than
> blindly assuming
> you know what's going on.

I had a "union all" view, which is actually a quite different animal than
a "union" view which needs to eliminate duplicates before further processing.

Andreas


pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: getpid() function
Next
From: Curt Sampson
Date:
Subject: Re: Rules and Views