"Jon Asher" <jon.asher@xxxxxxxxx> writes: > Anyone care to correct this regex for PostgreSQL? It works in C++ but > Postgres have no love for it: > -{0,1}\d*\.{0,1}\d+\^{0,1}\d*\.{0,1}\d+ It works fine in Postgres, AFAICT. Maybe you forgot to double the backslashes in a string literal? Otherwise, be more specific about your problem. regards, tom lane