Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

INSERT doc discrepancy



INSERT INTO table [ ( column [, ...] ) ]
    { DEFAULT VALUES | VALUES ( { _expression_ | DEFAULT } [, ...] ) [, ...] | query }
    [ RETURNING * | output_expression [ AS output_name ] [, ...] ]

but it seems if i want to return the result into a record i have to use it with INTO clause in the end:

        INSERT INTO tablename (
             a
            ,b
            ,c
        ) VALUES (
             in_a
            ,in_b
            ,in_c
        ) RETURNING * INTO _r;

using either

        INSERT INTO tablename (
             a
            ,b
            ,c
        ) VALUES (
             in_a
            ,in_b
            ,in_c
        ) RETURNING  _r;

or 

        INSERT INTO tablename (
             a
            ,b
            ,c
        ) VALUES (
             in_a
            ,in_b
            ,in_c
        ) RETURNING * AS _r;

didn't work on PostgreSQL 8.2.4 

Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group