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 661E852816 for ; Thu, 26 May 2005 08:50:32 -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 08740-02 for ; Thu, 26 May 2005 11:50:22 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.194]) by svr1.postgresql.org (Postfix) with ESMTP id 486A65280A for ; Thu, 26 May 2005 08:50:21 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 9so819894nzo for ; Thu, 26 May 2005 04:50:24 -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=SxVyxtldOwhAlX+N+PgOLgV5cB3v5qp4A48ehF6TWmHz75qAlCaAW5CHT6A5FJuZ+gAt/NEXVutOW0OGVxa7v3XPCqCfU+RWR/Q8jq7oQFuVCdzOfnCnm8bKS/bThe54qukOPEQYnxTsEYrHNsR+QIN1G2jrEnFCnhxvKbFZXmM= Received: by 10.36.129.15 with SMTP id b15mr546942nzd; Thu, 26 May 2005 04:50:24 -0700 (PDT) Received: from server ([210.245.57.85]) by mx.gmail.com with ESMTP id 12sm55664nzn.2005.05.26.04.50.23; Thu, 26 May 2005 04:50:24 -0700 (PDT) Message-ID: <004801c561e9$1c302a40$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 18:50:24 +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/221 X-Sequence-Number: 21534 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" 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