Tomasz Myrta <[EMAIL PROTECTED]> writes:
> Why the first expression is 25 times slower?
Hard to say, when you haven't shown us the schema. (Column datatypes,
definitions of available indexes, etc are all critical information for
this sort of question.)
regards, tom lane
When I try your script on current sources I get an error about
the values being too long for the varchar(15) on some of the
inserts. My guess is that on the older version the varchar(15)
is truncating and making it different from the varchar(80) in
the referenced table so it really is a foreign
I have something like this:
billy=# EXPLAIN SELECT * from kursy where id_trasy=1 and
data_kursu=date('2001-12-12');
NOTICE: QUERY PLAN:
Index Scan using pp on kursy (cost=0.00..51.55 rows=1 width=18)
billy=# EXPLAIN SELECT * from kursy where id_trasy=1
and data_kursu='2001-12-12';
NOTICE:
yves piel ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
there is a problem with foreign key
Long Description
I have got a 7.1 PGSQL/PG_dump version
I have a table wich references some values of another one with a foreign key
