On 12/11/2013 12:30 AM, Krzysztof Olszewski wrote:
select g.gd_index, gd.full_name
from gd g join gd_data gd on (g.id_gd = gd.id_gd)
where gd.id_gd_data = OR g.id_gd = ;
Have you tried writing the query to filter on gd.id_gd rather than
g.id_gd? I am not sure if the query planner will
kolsze...@gmail.com wrote
> Thanx for your answer
>
> My example is trivial because i want to show strange (for me) postgres
> behavior with dealing with primary keys (extreme example), in real
> situation user put search condition e.g. "Panas" and this generates query
> ...
> where gd.other_code
On Mon, 2013-12-16 at 11:42 +, Yuri Levinsky wrote:
> Dear Depesz,
> This is very problematic solution: I have to change whole!!! my code to put
> appropriate comment with query text before any query execution. In addition I
> would like to know current execution plan, that seems to be impos