Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <pierre.bachelart@belgacom.be>) id 1TEeWL-0002JM-RS
	for pgsql-sql@postgresql.org; Thu, 20 Sep 2012 11:02:14 +0000
Received: from mx23.belgacom.be ([213.181.45.233])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <pierre.bachelart@belgacom.be>) id 1TEeWI-0002Dd-Ni
	for pgsql-sql@postgresql.org; Thu, 20 Sep 2012 11:02:12 +0000
X-IronPort-AV: E=Sophos;i="4.80,453,1344204000"; d="scan'208,217";a="25798203"
Received: from unknown (HELO A03005.BGC.NET) ([10.120.129.161])
	by mx23.belgacom.be with ESMTP; 20 Sep 2012 13:01:17 +0200
X-TM-IMSS-Message-ID: <03a141570000b6ad@belgacom.be>
Received: from A04021.BGC.NET ([10.120.135.22]) by belgacom.be
	([10.120.129.161]) with ESMTP (TREND IMSS SMTP Service 7.1;
	TLSv1/SSLv3 AES128-SHA (128/128)) id 03a141570000b6ad ;
	Thu, 20 Sep 2012 13:01:15 +0200
Received: from A04059.BGC.NET ([10.121.135.30]) by A04021.BGC.NET
	([10.120.135.22]) with mapi id 14.01.0355.002; Thu, 20 Sep 2012 13:01:15
	+0200
From: "BACHELART PIERRE (CIS/SCC)" <pierre.bachelart@belgacom.be>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: matching a timestamp field
Thread-Topic: matching a timestamp field
Thread-Index: Ac2XHVl6Z/YUrpUBQZG3Rsr5m58Vjg==
Date: Thu, 20 Sep 2012 11:01:15 +0000
Message-ID: <3C56CD7AD881324BB4C60AA5CE2C5CC11720019A@A04059.BGC.NET>
Accept-Language: en-US, en-GB
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-originating-ip: [10.111.9.140]
Content-Type: multipart/alternative;
	boundary="_000_3C56CD7AD881324BB4C60AA5CE2C5CC11720019AA04059BGCNET_"
MIME-Version: 1.0
X-Pg-Spam-Score: -2.4 (--)
X-Archive-Number: 201209/47
X-Sequence-Number: 36849


--_000_3C56CD7AD881324BB4C60AA5CE2C5CC11720019AA04059BGCNET_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,


Why is my sql below accepted in 8.1.19 and refused in 8.4.9 ???
Is there something I have missed in the doc ?


Welcome to psql 8.1.19, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

ansroc=3D# select * from s12hwdb where record ~'2012-09-20' limit 5;
   host   | exchange |   rit   |  board   | var  | lceid | pceid | mnem  | =
eq | rtyp | rv |  cetype  |       record        | type | zone
----------+----------+---------+----------+------+-------+-------+-------+-=
---+------+----+----------+---------------------+------+------
and5032t | and5032t | 01a0301 | 21122994 | ebjb | 0000  | 000c  | con3a | e=
  | ef03 | b1 | plce#xfx | 2012-09-20 11:50:02 | H    | a1
and5032t | and5032t | 01a0307 | 21406298 | aaca | 0000  | 000c  | mmca  | e=
  | ef03 | b1 | plce#xfx | 2012-09-20 11:50:02 | H    | a1
and5032t | and5032t | 01a0309 | 21406298 | aaca | 0000  | 000c  | mmca  | s=
  | ef03 | b1 | plce#xfx | 2012-09-20 11:50:02 | H    | a1
and5032t | and5032t | 01a0311 | 21407930 | aaaa | 0000  | 000c  | mmcb  | e=
  | ef03 | b1 | plce#xfx | 2012-09-20 11:50:02 | H    | a1
and5032t | and5032t | 01a0313 | 21407932 | abca | 0000  | 000c  | mcud  | e=
  | ef03 | b1 | plce#xfx | 2012-09-20 11:50:02 | H    | a1
(5 rows)

ansroc=3D# \q



psql (8.4.9)
Type "help" for help.
ansroc=3D# select * from s12hwdb where record ~'2012-09-20' limit 5;
ERROR:  operator does not exist: timestamp without time zone ~ unknown
LINE 1: select * from s12hwdb where record ~'2012-09-20' limit 5;
                                           ^
HINT:  No operator matches the given name and argument type(s). You might n=
eed to add explicit type casts.
ansroc=3D#




Pierre.
+32 471 68 12 23


________________________________

***** Disclaimer *****
http://www.belgacom.be/maildisclaimer

--_000_3C56CD7AD881324BB4C60AA5CE2C5CC11720019AA04059BGCNET_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<style>
<!--
@font-face
	{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline}
span.EmailStyle17
	{font-family:"Calibri","sans-serif";
	color:windowtext}
.MsoChpDefault
	{font-family:"Calibri","sans-serif"}
@page WordSection1
	{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
	{}
-->
</style>
</head>
<body lang=3D"EN-GB" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello,</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Why is my sql below accepted in 8.1.19 and refused i=
n 8.4.9 ???</p>
<p class=3D"MsoNormal">Is there something I have missed in the doc ?</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Welcome to psql 8.1.19, the PostgreSQL interactive t=
erminal.</p>
<p class=3D"MsoNormal">Type:&nbsp; \copyright for distribution terms</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \h for help wit=
h SQL commands</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \? for help wit=
h psql commands</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \g or terminate=
 with semicolon to execute query</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \q to quit</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">ansroc=3D# select * from s12hwdb where record ~'2012=
-09-20' limit 5;</p>
<p class=3D"MsoNormal">&nbsp;&nbsp; host&nbsp;&nbsp; | exchange |&nbsp;&nbs=
p; rit&nbsp;&nbsp; |&nbsp; board&nbsp;&nbsp; | var&nbsp; | lceid | pceid | =
mnem&nbsp; | eq | rtyp | rv |&nbsp; cetype&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; record&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | type | zone<=
/p>
<p class=3D"MsoNormal">----------&#43;----------&#43;---------&#43;--------=
--&#43;------&#43;-------&#43;-------&#43;-------&#43;----&#43;------&#43;-=
---&#43;----------&#43;---------------------&#43;------&#43;------</p>
<p class=3D"MsoNormal">and5032t | and5032t | 01a0301 | 21122994 | ebjb | 00=
00&nbsp; | 000c&nbsp; | con3a | e&nbsp; | ef03 | b1 | plce#xfx | 2012-09-20=
 11:50:02 | H&nbsp;&nbsp;&nbsp; | a1</p>
<p class=3D"MsoNormal">and5032t | and5032t | 01a0307 | 21406298 | aaca | 00=
00&nbsp; | 000c&nbsp; | mmca&nbsp; | e&nbsp; | ef03 | b1 | plce#xfx | 2012-=
09-20 11:50:02 | H&nbsp;&nbsp;&nbsp; | a1</p>
<p class=3D"MsoNormal">and5032t | and5032t | 01a0309 | 21406298 | aaca | 00=
00&nbsp; | 000c&nbsp; | mmca&nbsp; | s&nbsp; | ef03 | b1 | plce#xfx | 2012-=
09-20 11:50:02 | H&nbsp;&nbsp;&nbsp; | a1</p>
<p class=3D"MsoNormal">and5032t | and5032t | 01a0311 | 21407930 | aaaa | 00=
00&nbsp; | 000c&nbsp; | mmcb&nbsp; | e&nbsp; | ef03 | b1 | plce#xfx | 2012-=
09-20 11:50:02 | H&nbsp;&nbsp;&nbsp; | a1</p>
<p class=3D"MsoNormal">and5032t | and5032t | 01a0313 | 21407932 | abca | 00=
00&nbsp; | 000c&nbsp; | mcud&nbsp; | e&nbsp; | ef03 | b1 | plce#xfx | 2012-=
09-20 11:50:02 | H&nbsp;&nbsp;&nbsp; | a1</p>
<p class=3D"MsoNormal">(5 rows)</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">ansroc=3D# \q</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">psql (8.4.9)</p>
<p class=3D"MsoNormal">Type &quot;help&quot; for help.</p>
<p class=3D"MsoNormal">ansroc=3D# select * from s12hwdb where record ~'2012=
-09-20' limit 5;</p>
<p class=3D"MsoNormal">ERROR:&nbsp; operator does not exist: timestamp with=
out time zone ~ unknown</p>
<p class=3D"MsoNormal">LINE 1: select * from s12hwdb where record ~'2012-09=
-20' limit 5;</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ^</p>
<p class=3D"MsoNormal">HINT:&nbsp; No operator matches the given name and a=
rgument type(s). You might need to add explicit type casts.</p>
<p class=3D"MsoNormal">ansroc=3D#</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal"><span style=3D"">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"">Pierre.</span></p>
<p class=3D"MsoNormal"><span style=3D"">&#43;32 471 68 12 23</span></p>
<p class=3D"MsoNormal">&nbsp;</p>
</div>
<br>
<hr>
<font face=3D"Arial" color=3D"Blue" size=3D"2"><br>
***** Disclaimer *****<br>
http://www.belgacom.be/maildisclaimer<br>
</font>
</body>
</html>

--_000_3C56CD7AD881324BB4C60AA5CE2C5CC11720019AA04059BGCNET_--