From 37273977cb76d48585db1bd3b3cd22a0f63d7011 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Sun, 12 Jul 1998 04:49:47 +0000
Subject: [PATCH] add mention of DISTINCT ON attrN

---
 src/bin/psql/psqlHelp.h | 10 +++++-----
 src/man/select.l        |  4 ++--
 2 files changed, 7 insertions(+), 7 deletions(-)

diff --git a/src/bin/psql/psqlHelp.h b/src/bin/psql/psqlHelp.h
index 91786543e4..0383b01a42 100644
--- a/src/bin/psql/psqlHelp.h
+++ b/src/bin/psql/psqlHelp.h
@@ -5,7 +5,7 @@
  *
  * Copyright (c) 1994, Regents of the University of California
  *
- * $Id: psqlHelp.h,v 1.44 1998/06/16 07:29:39 momjian Exp $
+ * $Id: psqlHelp.h,v 1.45 1998/07/12 04:49:47 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -150,7 +150,7 @@ static struct _helpStruct QL_HELP[] = {
 	{"create view",
 		"create a view",
 	"create view <view_name> as\n\
-\tselect\n\
+\tselect [distinct [on attrN]]\n\
 \t<expr1>[as <attr1>][,... <exprN>[as <attrN>]]\n\
 \t[from <from_list>]\n\
 \t[where <qual>]\n\
@@ -158,7 +158,7 @@ static struct _helpStruct QL_HELP[] = {
 	{"declare",
 		"set up a cursor",
 	"declare <cursorname> [binary] cursor for\n\
-\tselect [distinct]\n\
+\tselect [distinct [on attrN]]\n\
 \t<expr1> [as <attr1>],...<exprN> [as <attrN>]\n\
 \t[from <from_list>]\n\
 \t[where <qual>]\n\
@@ -239,7 +239,7 @@ static struct _helpStruct QL_HELP[] = {
 		"insert tuples",
 	"insert into <class_name> [(<attr1>...<attrN>)]\n\
 \tvalues (<expr1>...<exprN>) |\n\
-\tselect [distinct]\n\
+\tselect [distinct [on attrN]]\n\
 \t<expr1>,...<exprN>\n\
 \t[from <from_clause>]\n\
 \t[where <qual>]\n\
@@ -278,7 +278,7 @@ static struct _helpStruct QL_HELP[] = {
 	"rollback [transaction|work]"},
 	{"select",
 		"retrieve tuples",
-	"select [distinct on <attr>] <expr1> [as <attr1>], ... <exprN> [as <attrN>]\n\
+	"select [distinct [on <attrN>]] <expr1> [as <attr1>], ... <exprN> [as <attrN>]\n\
 \t[into [table] <class_name>]\n\
 \t[from <from_list>]\n\
 \t[where <qual>]\n\
diff --git a/src/man/select.l b/src/man/select.l
index 5ffa34922b..64c89e7f7f 100644
--- a/src/man/select.l
+++ b/src/man/select.l
@@ -1,12 +1,12 @@
 .\" This is -*-nroff-*-
 .\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/select.l,v 1.9 1998/06/24 13:21:29 momjian Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/select.l,v 1.10 1998/07/12 04:49:47 momjian Exp $
 .TH SELECT SQL 11/05/95 PostgreSQL PostgreSQL
 .SH NAME
 select - retrieve instances from a class
 .SH SYNOPSIS
 .nf
-\fBselect\fR [distinct]
+\fBselect\fR [distinct [on attr_name]]
     expression1 [\fBas\fR attr_name-1]
     {, expression-1 [\fBas\fR attr_name-i]}
     [\fBinto\fR [\fBtable\fR] classname]
-- 
2.11.0