BUG #13744: Postgresql function auto add 's' character to the end of string

Поиск
Список
Период
Сортировка
От b.phamhuu@jacobs-university.de
Тема BUG #13744: Postgresql function auto add 's' character to the end of string
Дата
Msg-id 20151029125730.3019.68524@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13744: Postgresql function auto add 's' character to the end of string  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13744
Logged by:          Bang
Email address:      b.phamhuu@jacobs-university.de
PostgreSQL version: 9.2.13
Operating system:   Centos 7
Description:

I've a function in Postgresql database. However, every time I run the
function in postgresql, it auto add character 's' behind of the query so it
will be error when execute (for example: WHAT IN HERE: query SELECT uom_id
FROM ps_quantity where id = 11s ). My version is Postgresql 9.2.13. How can
I solve this?

 CREATE OR REPLACE FUNCTION select_field(
    selected_table text,
    selected_field text,
    field_type_sample anyelement,
    where_clause text DEFAULT ''::text)
  RETURNS anyelement AS
$BODY$ DECLARE
    -- Log
    ME  constant text := 'selected_field()';
    -- Local variables
        _qry          varchar := '';
        _result_value ALIAS FOR $0;
    where_clause1 varchar := 'asdasdsad';
    BEGIN
    RAISE NOTICE 'FUNCTION: SELECT_FIELD';
    -- BANGPH
    RAISE NOTICE 'BANGPH - CHANGE 11s to 11';

        _qry := 'SELECT uom_id FROM ps_quantity where id = 11';

    RAISE NOTICE 'WHERE = %s', where_clause1;

    RAISE NOTICE 'WHAT IN HERE: query %s', _qry;

В списке pgsql-bugs по дате отправления:

Предыдущее
От: kchinnathambu@mdsol.com
Дата:
Сообщение: BUG #13746: SQL Query Window stopped working
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #13744: Postgresql function auto add 's' character to the end of string