From: | Egon Frerich <egon(at)frerich(dot)eu> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Query with type char |
Date: | 2017-02-16 10:14:08 |
Message-ID: | acf71403-7a70-9261-670a-ad9bc6d8c58b@frerich.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Moench-Tegeder | 2017-02-16 10:30:11 | Re: Query with type char |
Previous Message | pinker | 2017-02-16 10:04:49 | Re: Using ctid in delete statement |