Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3727397

Browse files
committed
add mention of DISTINCT ON attrN
1 parent76dd88f commit3727397

File tree

2 files changed

+7
-7
lines changed

2 files changed

+7
-7
lines changed

‎src/bin/psql/psqlHelp.h

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@
55
*
66
* Copyright (c) 1994, Regents of the University of California
77
*
8-
* $Id: psqlHelp.h,v 1.44 1998/06/16 07:29:39 momjian Exp $
8+
* $Id: psqlHelp.h,v 1.45 1998/07/12 04:49:47 momjian Exp $
99
*
1010
*-------------------------------------------------------------------------
1111
*/
@@ -150,15 +150,15 @@ static struct _helpStruct QL_HELP[] = {
150150
{"create view",
151151
"create a view",
152152
"create view <view_name> as\n\
153-
\tselect\n\
153+
\tselect [distinct [on attrN]]\n\
154154
\t<expr1>[as <attr1>][,... <exprN>[as <attrN>]]\n\
155155
\t[from <from_list>]\n\
156156
\t[where <qual>]\n\
157157
\t[group by <group_list>];"},
158158
{"declare",
159159
"set up a cursor",
160160
"declare <cursorname> [binary] cursor for\n\
161-
\tselect [distinct]\n\
161+
\tselect [distinct [on attrN]]\n\
162162
\t<expr1> [as <attr1>],...<exprN> [as <attrN>]\n\
163163
\t[from <from_list>]\n\
164164
\t[where <qual>]\n\
@@ -239,7 +239,7 @@ static struct _helpStruct QL_HELP[] = {
239239
"insert tuples",
240240
"insert into <class_name> [(<attr1>...<attrN>)]\n\
241241
\tvalues (<expr1>...<exprN>) |\n\
242-
\tselect [distinct]\n\
242+
\tselect [distinct [on attrN]]\n\
243243
\t<expr1>,...<exprN>\n\
244244
\t[from <from_clause>]\n\
245245
\t[where <qual>]\n\
@@ -278,7 +278,7 @@ static struct _helpStruct QL_HELP[] = {
278278
"rollback [transaction|work]"},
279279
{"select",
280280
"retrieve tuples",
281-
"select [distinct on <attr>] <expr1> [as <attr1>], ... <exprN> [as <attrN>]\n\
281+
"select [distinct[on <attrN>]] <expr1> [as <attr1>], ... <exprN> [as <attrN>]\n\
282282
\t[into [table] <class_name>]\n\
283283
\t[from <from_list>]\n\
284284
\t[where <qual>]\n\

‎src/man/select.l

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,12 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/select.l,v 1.9 1998/06/24 13:21:29 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/select.l,v 1.10 1998/07/12 04:49:47 momjian Exp $
44
.TH SELECT SQL 11/05/95 PostgreSQL PostgreSQL
55
.SH NAME
66
select - retrieve instances from a class
77
.SH SYNOPSIS
88
.nf
9-
\fBselect\fR [distinct]
9+
\fBselect\fR [distinct [on attr_name]]
1010
expression1 [\fBas\fR attr_name-1]
1111
{, expression-1 [\fBas\fR attr_name-i]}
1212
[\fBinto\fR [\fBtable\fR] classname]

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp