Re: [GENERAL] equal and like

2008-12-10 Thread Schwéger Gábor
Thank You. After reindex it's working fine. Gabor On Ked, December 9, 2008 23:06, Bill Moran wrote: > In response to "Schwéger Gábor" <[EMAIL PROTECTED]>: >> >> This is my first post to this list. >> Our database moved to a larger partition. >> And now I have a problem with a select query: >> db=

Re: [GENERAL] equal and like

2008-12-09 Thread Quan Zongliang
Hi, Gabor > The type of login is text. > What is the problem with the equal sign? > psql server version: 8.2.11 I had tested them, both got correct result. version: 8.2.11 & 8.3.5 for windows without partition Maybe, as Moran said, reindex it and try again. -

Re: [GENERAL] equal and like

2008-12-09 Thread Bill Moran
In response to "Schwéger Gábor" <[EMAIL PROTECTED]>: > > This is my first post to this list. > Our database moved to a larger partition. > And now I have a problem with a select query: > db=# SELECT id, login FROM u WHERE login LIKE 'bellamarth'; >id |login > +- > 17

[GENERAL] equal and like

2008-12-09 Thread Schwéger Gábor
Hi List, This is my first post to this list. Our database moved to a larger partition. And now I have a problem with a select query: db=# SELECT id, login FROM u WHERE login LIKE 'bellamarth'; id |login +- 173002 | bellamarth (1 row) db=# SELECT id, login FROM u WHER