On Wed, Jan 12, 2005 at 08:12:38PM +0000, Kanu Patel wrote: > > I have postgresql 7.4.6 running on linux7.2. I have created couple tables > and loaded about 15k entries using copy command. If I try to get one > perticular entry using "select * from table where col = 'value';" command, > it does not return anything (return 0 row). But if I use the command: select > * from table;, it returns all rows. It filters select commands if the > entries are inserted into the tables manually using inser commands instead > of copy.
Could the COPY data have extraneous whitespace, or could it be a case sensitivity issue? What happens when you issue a query like the following? SELECT '<' || col || '>' FROM foo WHERE col ILIKE '%value%'; If you still can't figure it out then please provide a real test case -- show the table definition, the exact query you're making, the output you expect (culled from an unrestricted SELECT, for example), and the output you actually got. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
