Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 86D6E632F60
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sun, 12 Apr 2009 03:06:09 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 21372-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sun, 12 Apr 2009 03:06:04 -0300 (ADT)
X-Greylist: delayed 00:06:40.790987 by SQLgrey-1.7.6
Received: from web33104.mail.mud.yahoo.com (web33104.mail.mud.yahoo.com
	[209.191.69.134])
	by mail.postgresql.org (Postfix) with SMTP id 38EF063424A
	for <pgsql-sql@postgresql.org>; Sun, 12 Apr 2009 03:05:20 -0300 (ADT)
Received: (qmail 1954 invoked by uid 60001); 12 Apr 2009 05:58:38 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1239515918; bh=dyhBxSwSgbMl8uPMg/fvpjw6Lbt0M80SySfDLcpKdzE=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=gy7iiNqE/N7AcbE5KBPXVm7pR2S6OoMrLXoYEK43rxIv+9Opyjp0sl2kNNWNpU8Et0R+v9+GWL4t0nhvHfcOC3QCV/NsGyKkFQuo+DqSCdUvh8bObOuZyIfaAgQAojijKInAGn6d3w2srOn0jBWutKbborceV+ZRYijcYWAcuCk=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=epkr0hLGEneTW02L9MdiD/Vvr8GSd7KPdfscqbTVnj/e1KLjU3E5p8EY8+PY7KVE8ITncS6gzVpc2kQLG4tWPCl9SgDg+gWo9DWI62RS6gwmNY0rGmV/uusApGIeCrYEewlnjqmfjIQwFohOGR527kEIZc58ct9RpwsIpDlM/to=;
Message-ID: <60074.805.qm@web33104.mail.mud.yahoo.com>
X-YMail-OSG: 
 g1RVUZAVM1kRhNwppjauHB2MaNdpsnVKKqvV7W8sIFqhTlv3TLh2WXWuLT8SY3.xLgUDs84ohRk9b5qq515425UQOF5x.0QGG9gLPxV1K.MUMBvADud4racQOvETn_XK6BscOFFDu8pw.RFiuz2N5iPDiUafucBDmbmYKNGjF.KBez7ii57p_Ugz5lZ2UE.U2EeNyynKL2YVSHj8EUCApFFwcCI3qZDl7cjgWYGDBBTCW8RMD.2BKepmDs5UkYOpYQVE4.pkVHyQauJbffbsWUJI5hnn4uNXBMTHotq6aaCgVHvn8mXJGCac.yLIRlS04GIuZw7a04VRE3PT3dwu7uzKayUHpLRvHIFsSQqnv0f4_MdCCpf1ww--
Received: from [59.180.95.136] by web33104.mail.mud.yahoo.com via HTTP;
	Sat, 11 Apr 2009 22:58:37 PDT
X-Mailer: YahooMailRC/1277.35 YahooMailWebService/0.7.289.1
Date: Sat, 11 Apr 2009 22:58:37 -0700 (PDT)
From: Rohit Suman <handsome_94@yahoo.com>
Subject: ERROR:  operator does not exist: date ~~ unknown
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1740481573-1239515917=:805"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200904/54
X-Sequence-Number: 32400


--0-1740481573-1239515917=:805
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi=0A=0AI've a table bins in which I've a column named "Date In"  which sto=
res values of "Date" type. I've postgresql 8.3.5=0A=0ANow when I execute qu=
ery " select * from bins where "Date In" like '%'; "I get the folowing erro=
r :=0A=0A=0A=0ASQL error:=0A=0AERROR:  operator does not exist: date ~~ unk=
nown=0ALINE 1: select * from bins where "Date In" like '%';=0A             =
                              ^=0AHINT:  No operator matches the given name=
 and argument type(s). You might need to add explicit type casts.=0AIn stat=
ement:=0Aselect * from bins where "Date In" like '%';=0APlease help...I'm s=
tuck for like 3-4 hours now on this X_X=0A=0ARohit=0A=0A=0A=0A      Add mor=
e friends to your messenger and enjoy! Go to http://messenger.yahoo.com/inv=
ite/
--0-1740481573-1239515917=:805
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial,helvetica,sans-serif;font-size:10p=
t"><div>Hi<br><br>I've a table bins in which I've a column named "Date In"&=
nbsp; which stores values of "Date" type. I've postgresql 8.3.5<br><br>Now =
when I execute query " select * from bins where "Date In" like '%'; " I get=
 the folowing error :<br><br><br><p><b>SQL error:</b><br></p><pre class=3D"=
data">ERROR:  operator does not exist: date ~~ unknown<br>LINE 1: select * =
from bins where "Date In" like '%';<br>                                    =
       ^<br>HINT:  No operator matches the given name and argument type(s).=
 You might need to add explicit type casts.</pre>=0A=09=09      <p><b>In st=
atement:</b><br>select * from bins where "Date In" like '%';</p><br>Please =
help...I'm stuck for like 3-4 hours now on this X_X<br><br>Rohit<br></div><=
/div><br>=0A      <!--6--><hr size=3D1></hr> Add more friends to your messe=
nger and enjoy! <a href=3D"http://in.rd.yahoo.com/tagline_messenger_6/*http=
://messenger.yahoo.com/invite/"> Invite them now.</a></body></html>
--0-1740481573-1239515917=:805--