BUG #10889: Cannot add 2 floats from regular expression

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

Responses

Browse pgsql-bugs by date

  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