X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DC38D52869 for ; Thu, 26 May 2005 12:49:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61515-10 for ; Thu, 26 May 2005 15:49:41 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.193]) by svr1.postgresql.org (Postfix) with ESMTP id 8E7E45280A for ; Thu, 26 May 2005 12:49:38 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 12so1168053nzp for ; Thu, 26 May 2005 08:49:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:cc:references:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=N6mvR25Ep8L3zVsgO/T5Xgae4nPd+FbdHNwoYdHGnBEBsAWjVHHzbDv3vibWwTyphODakYCwGAdcI/pTErpRhlY6W+Xq5/DVVK0q8obVvkDm4MAtO1LseKanmqLaJlCmm9HudVXUmjmV9NNRtLIbDsE+IofXHqzxdYnCg3zI2bo= Received: by 10.36.65.20 with SMTP id n20mr669453nza; Thu, 26 May 2005 08:49:37 -0700 (PDT) Received: from server ([210.245.57.85]) by mx.gmail.com with ESMTP id 14sm1585216nzp.2005.05.26.08.49.36; Thu, 26 May 2005 08:49:37 -0700 (PDT) Message-ID: <000901c5620a$919e1aa0$0201a8c0@server> From: "hatuan" To: "Tom Lane" Cc: References: <000501c5613e$592794c0$0201a8c0@server> <2417.1117055959@sss.pgh.pa.us> Subject: Re: Sql select like question. Date: Thu, 26 May 2005 22:49:53 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.821 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200505/224 X-Sequence-Number: 21537 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" To: "hatuan" Cc: Sent: Thursday, May 26, 2005 4:19 AM Subject: Re: [SQL] Sql select like question. > "hatuan" 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