Please see FAQ 4.9
http://postgresql.bteg.net/docs/faq-english.html#4.9
On Fri, 15 Jun 2001, Alexandr S. wrote:
>
> Bug: the index on INTEGER field does not work (PG 7.1.2).
>
> Test 1:
>
> 1) create table test_int(id int primary key);
>
> 2) insert 1 records in table test_int with perl
A few hours ago, I wrote:
>
> Simple add lines as shown:
>
> > for r in select * from tconcattest loop
> IF r.str IS NOT NULL THEN
> > output := output || r.str;
> END IF;
> > end loop;
>
This would probably be bet
Simple add lines as shown:
> for r in select * from tconcattest loop
IF r.str IS NOT NULL THEN
> output := output || r.str;
END IF;
> end loop;
- Andrew
> Looks like a bug to me, but I'd like not to have to reverse-engineer the
> test case before I can look at it. Could you provide some sample data,
> as well as the missing "Types" table declaration? Ideally a psql script
> file to load everything up from scratch and trigger the error ;-)
Well
Further to this, I wish you to note the following works correctly:
# select start, stop from mailredirs where start < CURRENT_TIMESTAMP;
start | stop
+
2000-10-31 17:26:52+11 | 2000-11-25 16:29:01+11
(1 row)
# select st
I just installed v7.0.3 release on a FreeBSD 4.x system. (Problem still happened in
7.0.2 too).
This is the problem I noticed:
# select * from mailredirs;
username |destination | start | stop |
reason
--++
Is this supposed to happen? I discovered this when I was experimenting with
converting a string to a number.
# SELECT to_number('12,454.8-', '99G999D9S');
to_number
---
-12454.8
(1 row)
# SELECT to_number('12,454.8-', '');
pqReadData() -- backend closed the channel unexpectedly.
