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" <tgl@sss.pgh.pa.us>
To: "hatuan" <hatuan05@gmail.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Thursday, May 26, 2005 4:19 AM
Subject: Re: [SQL] Sql select like question.
> "hatuan" <hatuan05@gmail.com> 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