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: (view raw, whole thread or download thread mbox)
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


Fernando Braga
VCNet Ltda.
Maceió (AL), Brazil
+55 (82) 336-2079

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


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-2017 The PostgreSQL Global Development Group