I'm trying to make a join between two columns, but one is a text and the other an integer. I get a standard : ERROR: operator does not exist: integer = text:
I read the manual this time and found that d2rq:numericColumn could be used if "the engine is for some reason unable to determine the correct column type by itself". I suppose that means that in a normal setup (D2RQ and PostgreSQL talking politely to each other), my d2rq:numericColumn setting is ignored I did not find any way in the docs to do somehting like CAST(table.column AS INTEGER) to use it within dr2q:join statement. Is table schema modification the only solution in my case ? thanks -- Dominique Guardiola, QUINODE • http://www.quinode.fr/ • Tel : 04.27.86.84.37 • Mob : 06.15.13.22.27 ------------------------------------------------------------------------------ Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ _______________________________________________ d2rq-map-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
