Re: Where clause...

am Sun, dem 03.02.2008, um 9:26:34 +0100 mailte Didier Gasser-Morlay folgendes:
> Hello,
>
> I have a table which a column "fee_type " declared as char(1)
>
> The column can contain 'I' (uppercase i), 'C' or 'R'
>
> When querying with Select * from <table> where fee_type in ('I', 'C')
>
> the query returns nothing.

Works for me:

test=*# select * from fee;
id | fee_type
----+----------
1 | C
2 | I
3 | c
4 | i
5 | a
(5 rows)

test=*# select * from fee where fee_type in ('C','I');
id | fee_type
----+----------
1 | C
2 | I
(2 rows)

Please show us your table description (\d table like
test=*# \d fee
Table "public.fee"
Column | Type | Modifiers
----------+--------------+-----------
id | integer |
fee_type | character(1) |

and tell us your PG-Version.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net