From: | Maximilian Tyrtania <lists(at)contactking(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Odd query result |
Date: | 2012-08-27 08:55:43 |
Message-ID: | 93BF653F-F56D-4A53-84E5-985153CF6BB6@contactking.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello from Berlin,
I can't quite make sense of this (running PG 9.0.3):
psql (9.0.3)
Type "help" for help.
FAKDB=# Select _rowid,f_firmen_isKunde(firmen),bezeichnung::text from firmen where (firmen.bezeichnung='Microsoft Deutschland GmbH');
_rowid | f_firmen_iskunde | bezeichnung
----------+------------------+----------------------------
1214700 | f | Microsoft Deutschland GmbH
15779700 | t | Microsoft Deutschland GmbH
166300 | t | Microsoft Deutschland GmbH
(3 rows)
FAKDB=# Select _rowid,f_firmen_isKunde(firmen),bezeichnung::text from
FAKDB-# firmen where
FAKDB-# (firmen.bezeichnung='Microsoft Deutschland GmbH') and
FAKDB-# (f_firmen_isKunde(firmen)=true) and firmen._rowid=15779700 ;
_rowid | f_firmen_iskunde | bezeichnung
----------+------------------+----------------------------
15779700 | t | Microsoft Deutschland GmbH
(1 row)
Fine. But this record won't be found if I omit the last condition.
FAKDB=# Select _rowid,f_firmen_isKunde(firmen),bezeichnung::text from firmen where (firmen.bezeichnung='Microsoft Deutschland GmbH') and (f_firmen_isKunde(firmen)=true);
_rowid | f_firmen_iskunde | bezeichnung
--------+------------------+----------------------------
166300 | t | Microsoft Deutschland GmbH
(1 row)
What might be up there?
Maximilian Tyrtania
http://www.contactking.de
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Williamson | 2012-08-27 09:27:19 | Re: PGBouncer Connection Using Perl DBI |
Previous Message | Pavel Stehule | 2012-08-27 04:04:28 | Re: 9.2 and index only scans |