Re: [BUGS] BUG #1392: could not select filter an entry from copied data table

2005-01-20 Thread Kanu Patel
Yes, the employee id=1 and it is text. So I agree with you that could be a space problem. How can I resolve that? May be change id as integer or real?   Thanks.   Michael Fuhr <[EMAIL PROTECTED]> wrote: On Mon, Jan 17, 2005 at 12:36:33PM -0800, Kanu Patel wrote:> I had an employee table with the f

Re: [BUGS] BUG #1392: could not select filter an entry from copied data table

2005-01-17 Thread Michael Fuhr
On Mon, Jan 17, 2005 at 12:36:33PM -0800, Kanu Patel wrote: > I had an employee table with the following columns in it: id, name, address, > phone, payinfo. > I had loaded the data using: "copy employee from 'employee.txt';" command. > I want to get namde of one employee, so I have entered the fo

Re: [BUGS] BUG #1392: could not select filter an entry from copied data table

2005-01-14 Thread Michael Fuhr
On Wed, Jan 12, 2005 at 08:12:38PM +, 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 no

[BUGS] BUG #1392: could not select filter an entry from copied data table

2005-01-13 Thread Kanu Patel
The following bug has been logged online: Bug reference: 1392 Logged by: Kanu Patel Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Linux Description:could not select filter an entry from copied data table Details: I have postgresql 7.4.