Re: [PERFORM] Trouble with LEFT JOIN using VIEWS.

2007-12-07 Thread Tom Lane
=?ISO-8859-2?Q?Piotr_Gasid=B3o?= <[EMAIL PROTECTED]> writes: > I've just hit problem, that is unusual for me. > View definition: > SELECT users.id, users.user_name, users.extra IS NOT NULL AS has_extra > FROM users; What you've got here is a non-nullable target list, which creates an optimi

[PERFORM] Trouble with LEFT JOIN using VIEWS.

2007-12-07 Thread Piotr Gasidło
Hello, I've just hit problem, that is unusual for me. quaker=> \d sites Table "public.sites" Column | Type| Modifiers ---+---+ id| integer