Bom, então provavelmente o problema é como JDBC que está usando, já que no PGAdmin3 funciona corretamente.
Lembre-se que a versão TEM QUE SER do postgresql 8.2...
Veja
http://jdbc.postgresql.org/download.html2007/8/3, Raimundo Alves <raimundoas@gmail.com>:
The following bug has been logged online:
Bug reference: 3509
Logged by: Raimundo Alves
Email address: raimundoas@gmail.com
PostgreSQL version: 8.2.4
Operating system: Windows
Description: bug with command from with two tables
Details:
i am using the postgres at an application Java with jdbc3.
i have two tables with this struct:
CREATE TABLE table1
(
field1 bigint,
field2 timestamp without time zone,
field3 integer[],
field4 text[],
field5 text[],
field6 text[],
field7 text[],
field8 integer[],
field9text[],
field10 character(1)[],
field11 real[],
field12 bigint[],
field13 timestamp without time zone[],
field14 boolean[],
field15 bytea[],
field16 text[],
field17 double precision[]
)
CREATE TABLE table2
(
field1 bigint,
field2 bigint,
field3 character varying(200),
field4 boolean
)
when i use this command "select * from table1, table2 where table2.field1 =
1 and table2.field3 = 'value' and table2.field2 = table1.field1", the return
come field7 of table1 with values incomplete.
other problem is when exist only one register in database and i execute
select "select * from table1 where 'value' = any (objects.field4) and 1 =
any (objects.field3)", not return the register.
all these commands when i execute in "execute query" of pgadminIII not have
problem.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
William Leite Araújo
Estudante de paternidade - 17a semana