Le 6 déc. 2011 à 17:54, Dominique Guardiola a écrit : > > 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
