Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id EDFA96335E1
	for <pgsql-docs-postgresql.org@mail.postgresql.org>;
	Tue, 14 Apr 2009 11:45:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 40407-01 for
	<pgsql-docs-postgresql.org@mail.postgresql.org>;
	Tue, 14 Apr 2009 11:44:58 -0300 (ADT)
X-Greylist: delayed 00:10:59.856133 by SQLgrey-1.7.6
Received: from mo-p00-ob.rzone.de (mo-p00-ob.rzone.de [81.169.146.161])
	by mail.postgresql.org (Postfix) with ESMTP id C7499633533
	for <pgsql-docs@postgresql.org>; Tue, 14 Apr 2009 11:45:07 -0300 (ADT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; t=1239720305; l=1290;
	s=domk; d=tim-landscheidt.de;
	h=Content-Type:MIME-Version:Date:From:Subject:To:X-RZG-CLASS-ID:
	X-RZG-AUTH; bh=14ME8fNnB0my+cd3aqO6+DLBC37+D6GnnM4W+MVCRrk=;
	b=RfNtZ1W/tU/RVZJvisbXCs0kyJy95U6OWPm45Dme+xqJ3W2E3MiSzOwcZpHkw4v4tnJ
	NIrwekcI7jCP7/R+OKhz/kg/p531V4Wv6vMmoPEHwj7NO4lrSi+FND/tGc2I8yIPRbHp4
	vfXWDgkvLenWUgyZwfq9tTgckZ+VI/zYhWI=
X-RZG-AUTH: 
 :O2kGeEG7b/pS1FmwRjK/iE70SAFAhFmfc+zHXduyf9B4PVbPtDGGAwPQZz33HJ8JR0TpFxSNeQ==
X-RZG-CLASS-ID: mo00
Received: from lockfix.tim-landscheidt.de
	(e177126249.adsl.alicedsl.de [85.177.126.249])
	by post.strato.de (fruni mo12) (RZmta 18.28)
	with ESMTP id N02427l3EEPG5r for <pgsql-docs@postgresql.org>;
	Tue, 14 Apr 2009 16:34:01 +0200 (MEST)
Received: from lockfix.tim-landscheidt.de (localhost.localdomain [127.0.0.1])
	by lockfix.tim-landscheidt.de (8.14.3/8.14.3) with ESMTP id
	n3EEXxvo005365
	for <pgsql-docs@postgresql.org>; Tue, 14 Apr 2009 14:34:00 GMT
Received: (from tim@localhost)
	by lockfix.tim-landscheidt.de (8.14.3/8.14.3/Submit) id n3EEXxZM005363;
	Tue, 14 Apr 2009 14:33:59 GMT
X-Authentication-Warning: lockfix.tim-landscheidt.de: tim set sender to
	tim@tim-landscheidt.de using -f
To: pgsql-docs@postgresql.org
Subject: Clarification of psql's "-c" output
From: Tim Landscheidt <tim@tim-landscheidt.de>
Date: Tue, 14 Apr 2009 14:33:58 +0000
Message-ID: <m3myajxq21.fsf@lockfix.tim-landscheidt.de>
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.3 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200904/36
X-Sequence-Number: 5124

Hi,

as a user, I'd appreciate if psql's execution and output be-
haviour when using the "-c" option would be explained more
detailed in the documentation. Based on psql 8.*3*.7 (don't
know if that will change in 8.4), I'd suggest:

| [tim@lockfix ~/Desktop/Agenda/pgsql/doc/src/sgml/ref]$ cvs diff -u psql-ref.sgml
| Index: psql-ref.sgml
| ===================================================================
| RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v
| retrieving revision 1.223
| diff -u -r1.223 psql-ref.sgml
| --- psql-ref.sgml       8 Apr 2009 22:29:30 -0000       1.223
| +++ psql-ref.sgml       14 Apr 2009 14:30:17 -0000
| @@ -99,6 +99,15 @@
|         string to divide it into multiple transactions.  This is
|         different from the behavior when the same string is fed to
|         <application>psql</application>'s standard input.
| +       Only the result of the <emphasis>last
| +       explicit</emphasis> SQL command (i. e. not a
| +       transaction wrapper added
| +       by <application>psql</application>) is displayed.
| +      </para>
| +      <para>
| +       If multiple <option>-c</option> options are given,
| +       only the <emphasis>last</emphasis> option is
| +       evaluated.
|        </para>
|        </listitem>
|      </varlistentry>
| [tim@lockfix ~/Desktop/Agenda/pgsql/doc/src/sgml/ref]$

TIA,
Tim