[GENERAL] Postgres friendly RegEx?
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+ This regex accepts (any num)^(pos num) such as: 45.2^3 -45.2^3 10^2.5
Re: [GENERAL] Postgres friendly RegEx?
Jon Asher [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Postgres friendly RegEx?
In Postgres, it appears to be returning false positives: select * from (select '52'::varchar As val) d where d.val ~ '-{0,1}\\d*\\.{0,1}\\d+\\^{0,1}\\d*\\.{0,1}\\d+' returns a record. In C++ only such values match: 45.2^3 or -45.2^3 or 10^2.5 On 12/12/06, Tom Lane [EMAIL PROTECTED] wrote: Jon Asher [EMAIL PROTECTED] 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
Re: [GENERAL] Postgres friendly RegEx?
Please ignore, my mistake in the translation to Pg regex ! On 12/12/06, Jon Asher [EMAIL PROTECTED] wrote: In Postgres, it appears to be returning false positives: select * from (select '52'::varchar As val) d where d.val ~ '-{0,1}\\d*\\.{0,1}\\d+\\^{0,1}\\d*\\.{0,1}\\d+' returns a record. In C++ only such values match: 45.2^3 or -45.2^3 or 10^2.5 On 12/12/06, Tom Lane [EMAIL PROTECTED] wrote: Jon Asher [EMAIL PROTECTED] 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
Re: [GENERAL] Postgres friendly RegEx?
You don't give a pg version. It looks legal to me as of 8.1. Try replacing all the {0,1} with ? - but check the manual for regex_flavor too. Is there any chance you're in basic mode? - Jeremy ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings