Le 6 déc. 2011 à 13:15, Richard Cyganiak a écrit : > > Googling shows that there might be some Postgres magic to re-add the implicit > casts: > http://www.depesz.com/index.php/2008/05/05/error-operator-does-not-exist-integer-text-how-to-fix-it/
Great, this solved the problem For the record , and just in case this page disappears, this is since postgresql 8.3 To have PG cast implicitly again text to integer, juste type in psql : CREATE FUNCTION text_to_int(TEXT) RETURNS INT4 AS ' SELECT int4in(textout($1)); ' LANGUAGE SQL STRICT IMMUTABLE; CREATE CAST (TEXT AS INT4) WITH FUNCTION text_to_int(TEXT) AS IMPLICIT; -- Dominique Guardiola, QUINODE • http://www.quinode.fr/ • Tel : 04.27.86.84.37 • Mob : 06.15.13.22.27 -- 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
