Skip site navigation (1) Skip section navigation (2)

NULL fields in inner join

From: Fernando Braga <fernando(at)vcnet(dot)com(dot)br>
To: pgsql-odbc(at)postgresql(dot)org
Subject: NULL fields in inner join
Date: 2003-01-15 17:57:30
Message-ID: 20030115155730.3c6f436a.fernando@vcnet.com.br (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Guys,

If i run an INNER JOIN through odbc, all NULL fields are retrieved with
values (??!). And worse of that, when this occurs, the lines with NULL
fields comes three times. 

Of course, when I do the SQL on the linux server, it comes correct

Have anybody experienced this behaviour ?

I've attached linux_server.txt and xp_client.jpg

-- 
[]'s,

Fernando Braga
VCNet Ltda.
MaceiĆ³ (AL), Brazil
fernando(at)vcnet(dot)com(dot)br
+55 (82) 336-2079



Attachment: xp_client.png
Description: image/png (63.5 KB) (inlined above)
Attachment: linux-server.txt
Description: text/plain (5.1 KB)

Responses

pgsql-odbc by date

Next:From: Benjamin ScherreyDate: 2003-01-15 21:12:17
Subject: Trouble with slow ODBC query via Access
Previous:From: Hiroshi InoueDate: 2003-01-15 15:30:39
Subject: Re: Question about cursor behavior and declare/fetch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group