[asterisk-bugs] [JIRA] (ASTERISK-29293) Limit realtime_pgsql() to return one (no more) record

[Boris P. Korzun (JIRA)]

Boris P. Korzun created ASTERISK-29293:
------------------------------------------

             Summary: Limit realtime_pgsql() to return one (no more) record
                 Key: ASTERISK-29293
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29293
             Project: Asterisk
          Issue Type: Improvement
      Security Level: None
          Components: Resources/res_config_pgsql
    Affects Versions: 18.2.0, 16.16.0
            Reporter: Boris P. Korzun


There's no a SELECT {{LIMIT}} clause in {{realtime_pgsql()}}. But there's the limit in {{realtime_handler()}} at res_config_sqlite.
It's needed to use {{realtime_multi_pgsql()}} for getting multiple rows from an SQL query.

It's suggested to add {{LIMIT}} clause to {{realtime_pgsql()}} and refactor the function.



--
This message was sent by Atlassian JIRA
(v6.2#6252)