Re: Sql select like question.

From: "hatuan" <hatuan05(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Sql select like question.
Date: 2005-05-26 15:49:53
Message-ID: 000901c5620a$919e1aa0$0201a8c0@server
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

> "hatuan" <hatuan05(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Hammond 2005-05-26 16:33:32 Re: Duplicated records
Previous Message Tom Lane 2005-05-26 14:51:56 Re: Sql select like question.