Re: matching a timestamp field - Mailing list pgsql-sql

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=# 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=# \q

psql (8.4.9)

Type "help" for help.

ansroc=# 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 need to add explicit type casts.

ansroc=#

Pierre.

+32 471 68 12 23