Re: [SQL] Sql select like question.

2005-05-26 Thread hatuan
My version is PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) - Original Message - From: Tom Lane [EMAIL PROTECTED] To: hatuan [EMAIL PROTECTED] Cc: pgsql-sql@postgresql.org Sent: Thursday, May 26, 2005 4:19 AM Subject: Re: [SQL] Sql select like

Re: [SQL] Sql select like question.

2005-05-26 Thread Tom Lane
hatuan [EMAIL PROTECTED] writes: My version is PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) Well, if it's 8.0.3 then you've found a new variant of the problem, but we cannot fix it without a complete test case. Please read the bug reporting

Re: [SQL] Sql select like question.

2005-05-26 Thread hatuan
select like question. hatuan [EMAIL PROTECTED] writes: I have a select query Select * from A where id like 'US%' In pgAdmin i have error : ERROR: unsupported type: 136452. What PG version is this? There were some bugs of that ilk in 8.0..8.0.2, but I think they are all fixed in 8.0.3

Re: [SQL] Sql select like question.

2005-05-25 Thread Tom Lane
hatuan [EMAIL PROTECTED] writes: I have a select query Select * from A where id like 'US%' In pgAdmin i have error : ERROR: unsupported type: 136452. What PG version is this? There were some bugs of that ilk in 8.0..8.0.2, but I think they are all fixed in 8.0.3. Leastwise your example