add mention of DISTINCT ON attrN

bmomjian · bmomjian · commit 37273977cb76 · 1998-07-12T04:49:47.000Z
diff --git 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,15 +150,15 @@ 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\
 \t[group by <group_list>];"},
 	{"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
@@ -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]
