Hi,
On Sat, Nov 27, 2010 at 5:26 PM, [email protected] <[email protected]> wrote:
>>
>>>> Having a less ugly way of doing equality querying would be useful;
>>>> that would be a good feature request.
>>>
>>> Ok, so where should I report it ? ;-)
>>
>> now that's an easy one:
>> http://sourceforge.net/tracker/?group_id=160139&atid=814653
>
> https://sourceforge.net/tracker/?func=detail&aid=3120707&group_id=160139&atid=814653
Ok, this is fixed in rev1573. I used the operator == instead of =. It
might even be worth considering using @=, since substructure and
superstructure searches are @> and <@, respectively.
Here are a couple of examples:
emolecules=# select 'c1cnncc1'::mol=='N1=NC=CC=C1'::mol;
?column?
----------
t
(1 row)
emolecules=# select 'c1cnncc1'::mol=='N1=CC=CC=C1'::mol;
?column?
----------
f
(1 row)
emolecules=# explain select * from mols where
m=='COC(=O)c1n(C)cc(S(NCCc2cccc(C)c2)(=O)=O)c1'::mol;
QUERY PLAN
------------------------------------------------------------------------
Index Scan using molidx on mols (cost=0.00..13.64 rows=1 width=546)
Index Cond: (m == 'COC(=O)c1n(C)cc(S(NCCc2cccc(C)c2)(=O)=O)c1'::mol)
(2 rows)
emolecules=# select * from mols where
m=='COC(=O)c1n(C)cc(S(NCCc2cccc(C)c2)(=O)=O)c1'::mol;
id | m
---------+--------------------------------------------
2667221 | COC(=O)c1n(C)cc(S(NCCc2cccc(C)c2)(=O)=O)c1
(1 row)
Best Regards,
-greg
------------------------------------------------------------------------------
Oracle to DB2 Conversion Guide: Learn learn about native support for PL/SQL,
new data types, scalar functions, improved concurrency, built-in packages,
OCI, SQL*Plus, data movement tools, best practices and more.
http://p.sf.net/sfu/oracle-sfdev2dev
_______________________________________________
Rdkit-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
