I have fixed it. I have pg8.03 but database is 8.0. I dump database and reload it, it work well. Thank for your help. ----- 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 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. Leastwise your example doesn't fail for > me ... > > regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])