-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Why are there 0 rows? I expect 3 rows:
> mydb=# SELECT * FROM sample_char;
> sp1 | sp2 | sp3
> -----+-----------------+-----
> 1 | Bremen |
> 2 | Hamburg |
> 4 | Toronto |
> 3 | Bern | j
> (4 rows)
>
> mydb=# SELECT * FROM sample_char WHERE sp3 = 'j';
> sp1 | sp2 | sp3
> -----+-----------------+-----
> 3 | Bern | j
> (1 row)
>
> mydb=# SELECT * FROM sample_char WHERE sp3 <> 'j';
> sp1 | sp2 | sp3
> -----+-----+-----
> (0 rows)
Egon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)
iQIcBAEBAgAGBQJYpXtvAAoJECc7nbY+bg5uu38P/jXtMHU6AeNwNY5X+B3B9XnD
Wy6AChGzxl1z3pQLpKLrIHPI+y0FFx68vV6TBxpzW/wvpYE7rTM2UfLFyUmcflim
nEhQPUgK/YW3A5yKbjlRQasaosiBrvTvqlP8dSyhIASC1Jxwa152xaTrYOw9+ANO
Z/prP4X1GF7m29P0ULFxthpJlA3FOgtueKcwCVkDQVb2eRISFX8pzhuWKHFHukjx
avMhTo7s0n2unZGmtqrC1m59MR5WYoxbc7Dmwg82/jLqEf4ZYCc4tniqiysl3Tzc
i55xH/aqzVAXhC9PHCxoTU8ey2vyGogRObHo5tCqUpMPNoz0zbeSFrmb829fi3xV
XOKkerx2xXOnxkZkYfCH/a50eWdt9+Nw/ktuHU7G2/UIJQH3DxPi91nuY6trpO5e
nOSqi64F9gm12trCe14Jk8z/Ea7NZCCL5GNrQKXj4zkJF1AagG+bzsefZRz/fkK3
m9Nc2AS9J27mk0jx2SuCc5hHx6o8IdsemZacAamjFa/TYvOau+c6fbHKVvU79uhE
Wxdchse2Zo0/wC6o8nlQqTKmX4xfYKA5Oqk6gmOXC5fqLNOzIYb04IIF6zZAw9Sk
CELmOHyP0ZVyQhAVipqrepgbWhIrRVZV0+a+h5IO/s4QoenFjNV+pKnnwj9BCjw7
duk+MVwoHi6fZk6z601b
=LHt3
-----END PGP SIGNATURE-----