Re: [GENERAL] INSERT doc discrepancy

2007-08-28 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Kristo Kaiv wrote: >> but it seems if i want to return the result into a record i have to use it >> with INTO clause in the end: > Ah, you are using it in plpgsql! OK, but the explanation to the > discrepancy is that the second INTO is not part of the

Re: [GENERAL] INSERT doc discrepancy

2007-08-28 Thread Alvaro Herrera
Kristo Kaiv wrote: > 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

[GENERAL] INSERT doc discrepancy

2007-08-28 Thread Kristo Kaiv
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