Thread: pgsql/src/backend/parser parse_target.c

pgsql/src/backend/parser parse_target.c

From
"Marc G. Fournier"
Date:
CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    scrappy@hub.org    01/09/10 10:53:10

Modified files:
    src/backend/parser: parse_target.c

Log message:
    Bug #1: attribute name when column is type cast:

    Given the following table:

    test=# \d f
    Table "f"
    Column |  Type   | Modifiers
    --------+---------+-----------
    i      | integer |
    test   | text    |

    If I do the following:

    test=# insert into f values(1,'test');
    INSERT 139549 1
    test=# select i::int8,test from f;
    ?column? | test
    ----------+------
    1 | test
    (1 row)

    It doesn't make much sense that the first column should be called
    '?column?'.

    The patch results in the output appearing like this:

    test=# select i::int8,test from f;
    i | test
    ---+------
    1 | test
    (1 row)

    ----------

    Gavin Sherry