jez.w...@bull.net writes: > *************** > *** 347,354 **** > three | f1 | exp_ln_f1 > -------+----------------------+----------------------- > | 1004.3 | 1004.3 > ! | 1.2345678901234e+200 | 1.23456789012338e+200 > ! | 1.2345678901234e-200 | 1.23456789012339e-200 > (3 rows) > -- cube root > --- 347,354 ---- > three | f1 | exp_ln_f1 > -------+----------------------+----------------------- > | 1004.3 | 1004.3 > ! | 1.2345678901234e+200 | 1.23456789012337e+200 > ! | 1.2345678901234e-200 | 1.2345678901234e-200 > (3 rows)
This doesn't seem terribly surprising as a platform-specific difference. > -- T581 regular expression substring (with SQL99's bizarre regexp syntax) > SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d)#"%' FOR '#') AS "bcd"; > ! ERROR: invalid regular expression: parentheses () not balanced > ! CONTEXT: SQL function "substring" statement 1 This however isn't too good. It suggests a platform-specific issue in the regex library, but hard to say what. Can you dig a little deeper, maybe get a stack trace back from the call to errfinish()? Does compiling with -O0 change the behavior? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs