On Thu, Dec 20, 2001 at 09:38:15AM +0100, t(dot)ngockhoi(at)bpf(dot)vnu(dot)com wrote:
>
>
>
> HI ALL,
>
> I don't no why i can't compare varchar with string const :
>
> SELECT * FROM XXX WHERE stvarchar = 'somestring' ;
Does this work? (Untested)
SELECT * FROM XXX WHERE stvarchar = 'somestring'::varchar ;
HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.