> Here's version which uses trim (actually, ltrim and rtrim), but the best > way to tell what's faster is to try both versions with your data: > > func.rtrim(func.ltrim(Point.data, 'POINT('), ')') > That is awesome! Thank you very much! Now I understand why he tried to call btrim() in my faulty version above. (I wondered about the 'b')
Stuff like this should be part of the documentation. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/23bPLpfAqTkJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.