From: | "BACHELART PIERRE (CIS/SCC)" <pierre(dot)bachelart(at)belgacom(dot)be> |
---|---|
To: | "BACHELART PIERRE (CIS/SCC)" <pierre(dot)bachelart(at)belgacom(dot)be>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: matching a timestamp field |
Date: | 2012-09-20 12:21:56 |
Message-ID: | 3C56CD7AD881324BB4C60AA5CE2C5CC1172001FC@A04059.BGC.NET |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
The solution I just found on the Net (Thanks to Samuel Gendler)
ansroc=# select * from s12hwdb where record::text ~ '2012-09-20 11:50:02' 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)
But I still can not find this in the doc.
From: BACHELART PIERRE (CIS/SCC) [mailto:pierre(dot)bachelart(at)belgacom(dot)be]
Sent: Thursday 20 September 2012 13:01
To: pgsql-sql(at)postgresql(dot)org
Subject: matching a timestamp field
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
________________________________
***** Disclaimer *****
http://www.belgacom.be/maildisclaimer
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2012-09-22 08:08:17 | Re: matching a timestamp field |
Previous Message | BACHELART PIERRE (CIS/SCC) | 2012-09-20 11:01:15 | matching a timestamp field |