Hello there I use the function text_ge(text, text) under version 7.03 and it was just fine. After upgrading to version 7.2 this function doesn't work anymore.
this statement shows all the records even if the greatest year is 2002 in ul_datum : select * from userlog where text_ge(ul_datum, '01.01.2004') Thanks in advance ... Juerg Rietmann __________________________________________________ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland internet : www.pup.ch phone : +4141 790 4040 fax : +4141 790 2545 mobile : +4179 211 0315 __________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
