This appears to be fixed:
test=> CREATE TABLE sheep (cow text);
CREATE
test=> CREATE INDEX goat ON sheep (cow);
CREATE
test=> ALTER TABLE sheep RENAME cow TO chicken;
ALTER
test=> \d sheep
Table "sheep"
Column | Typ
[EMAIL PROTECTED] writes:
> The following pattern matches do not work:
> LIKE '%\_%'
> LIKE '%\_'
> LIKE '\_%'
You are short a backslash: what the LIKE operator is seeing is just
%_%, etc, which naturally matches anything. You gotta double the
backslashes, because one backslash will be eaten by
> Now, Here's where things get weird.
>
> fdb=> explain SELECT count(*) FROM mfps_orderinfo_435 WHERE order_date =
> current_date;
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=13532.12..13532.12 rows=1 width=0)
> -> Seq Scan on mfps_orderinfo_435 (cost=0.00..13528.77 rows=1340
> width=0)
