In fact I'm trying to migrate a database from Informix IDS to Postgres. This IDS database uses CHAR so I just let the same. Now I'm conviced that I sould convert CHAR to VARCHAR.
Thanks. > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] la part de Dani Oderbolz > Envoye : mercredi 25 juin 2003 14:19 > A : [EMAIL PROTECTED] > Objet : Re: [SQL] TR: Like and = > > > Nicolas JOUANIN wrote: > > >Hi, > > > > Thanks for your help. In fact that means 2 solutions for this: > > > >1) select * from pdi where rtrim(pdi) = '1006666058' > > > >or > > > >2) Use VARCHAR instead of CHAR > > > >I don't which is the best , but both are working. > > > >Nicolas. > > > > > > Do you have a specific reason why to use CHAR? > I use CHAR only for certain one-byte flags, and even there its use is > debatable. > I would use VARCHAR; if I was you. > > Cheers, > Dani > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
