Re: [GENERAL] varchar[] or text[]

2010-07-22 Thread Peter C. Lai
This was discussed yesterday and previously. Please read the archives. There is no positive performance reason to use varchar instead of text. On 2010-07-22 05:38:14PM +0200, Armand Turpel wrote: > Hi, > I know this issue was controversed discussed. Some one see no really > benefits of using v

Re: [GENERAL] varchar or text

2008-04-29 Thread Martijn van Oosterhout
On Tue, Apr 29, 2008 at 09:36:31AM +0200, Pascal Cohen wrote: > I am with 8.3.1 release but I mentioned that this appears with spaces at > then end not with standard chars. Of course your examples are working > fine but insert something like 'abc' (with several spaces and it > will work

Re: [GENERAL] varchar or text

2008-04-29 Thread Pascal Cohen
Guillaume Lelarge wrote: Pascal Cohen a écrit : I had a look in previous posts in the forum but could not find the answer I was looking for. My question is should I switch from varchar to text. We have "discovered" although it seems to be SQL that adding something like 'text ' to

Re: [GENERAL] varchar or text

2008-04-28 Thread Guillaume Lelarge
Pascal Cohen a écrit : I had a look in previous posts in the forum but could not find the answer I was looking for. My question is should I switch from varchar to text. We have "discovered" although it seems to be SQL that adding something like 'text ' to a varchar(50) just silent