From: | jakub(dot)vrbas(at)inspire(dot)cz |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #10889: Cannot add 2 floats from regular expression |
Date: | 2014-07-07 13:58:24 |
Message-ID: | 20140707135824.2752.47779@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 10889
Logged by: Jakub Vrbas
Email address: jakub(dot)vrbas(at)inspire(dot)cz
PostgreSQL version: 9.1.13
Operating system: Debian
Description:
I have test_column (of type character varying). If I parse a float by
regular expression, it isn't possible to add it to another float from
regular expression.
Example:
SELECT
(regexp_matches(test_column, '([0-9\.]*)'))[1]::float
+
(regexp_matches(test_column, '([0-9\.]*)'))[1]::float
FROM test_table
Results in "ERROR: functions and operators can take at most one set
argument"
Example 2 is OK:
SELECT
float_column
+
float_column
FROM (
SELECT
(regexp_matches(test_column, '([0-9\.]*)'))[1]::float AS float_column
FROM test_table
) foo
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-07-07 14:54:10 | Re: BUG #10888: application is getting hanged in the poll() function of libpq.so. |
Previous Message | Asif Naeem | 2014-07-07 08:59:35 | Re: [BUGS] BUG #9652: inet types don't support min/max |