> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Laurent Martelli <[EMAIL PROTECTED]> writes:
>> The pictures table is scanned, but it's not needed.
Tom> Yes it is. For example, if pictures is empty then the view
Tom> yields zero rows. Omitting the join to pictures could give a
Laurent Martelli <[EMAIL PROTECTED]> writes:
> The pictures table is scanned, but it's not needed.
Yes it is. For example, if pictures is empty then the view yields
zero rows. Omitting the join to pictures could give a different result.
regards, tom lane
---
Hello,
I'm using postgresql 7.4.2, and I have this view:
slooze=# \d userpictures2
Vue «public.userpictures2»
Colonne | Type | Modificateurs
-+--+---
pictureid | integer |
rollid | character v
