Commit7c07b13

Neil Conway

committed

Add the function's volatility to the output of psql's \df+ command.

Update the psql reference page accordingly.

1 parent867e2c9 commit7c07b13Copy full SHA for 7c07b13

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.191 2007/05/03 15:47:48 alvherre Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.192 2007/06/28 06:40:16 neilc Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -976,7 +976,7 @@ testdb=>`
`976`	`976`	`class="parameter">pattern</replaceable>`
`977`	`977`	`is specified, only functions whose names match the pattern are shown.`
`978`	`978`	`If the form <literal>\df+</literal> is used, additional information about`
`979`		`- each function, including language and description, is shown.`
	`979`	`+ each function, includingvolatility,language, source code and description, is shown.`
`980`	`980`	`</para>`
`981`	`981`
`982`	`982`	`<note>`

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`*`
`4`	`4`	`* Copyright (c) 2000-2007, PostgreSQL Global Development Group`
`5`	`5`	`*`
`6`		`- * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.155 2007/03/19 23:38:31 wieck Exp $`
	`6`	`+ * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.156 2007/06/28 06:40:16 neilc Exp $`
`7`	`7`	`*/`
`8`	`8`	`#include"postgres_fe.h"`
`9`	`9`	`#include"describe.h"`
`@@ -205,11 +205,16 @@ describeFunctions(const char *pattern, bool verbose)`
`205`	`205`
`206`	`206`	`if (verbose)`
`207`	`207`	`appendPQExpBuffer(&buf,`
	`208`	`+",\n CASE\n"`
	`209`	`+" WHEN p.provolatile = 'i' THEN 'immutable'\n"`
	`210`	`+" WHEN p.provolatile = 's' THEN 'stable'\n"`
	`211`	`+" WHEN p.provolatile = 'v' THEN 'volatile'\n"`
	`212`	`+"END as \"%s\""`
`208`	`213`	`",\n r.rolname as \"%s\",\n"`
`209`	`214`	`" l.lanname as \"%s\",\n"`
`210`	`215`	`" p.prosrc as \"%s\",\n"`
`211`	`216`	`" pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"",`
`212`		`-_("Owner"),_("Language"),`
	`217`	`+_("Volatility"),_("Owner"),_("Language"),`
`213`	`218`	`_("Source code"),_("Description"));`
`214`	`219`
`215`	`220`	`if (!verbose)`

Comments

(0)