Commit362a894

committed

[Doc]: Replace SELECT version() by SELECT pgpro_version()

1 parent5491b1d commit362a894Copy full SHA for 362a894

File tree

-6

lines changed

-6

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -6469,13 +6469,13 @@ EXEC SQL END DECLARE SECTION;`
`6469`	`6469`	`ECPGdebug(1, stderr);`
`6470`	`6470`
`6471`	`6471`	`EXEC SQL CONNECT TO :dbname USER :user;`
`6472`		`- EXEC SQL SELECTversion() INTO :ver;`
	`6472`	`+ EXEC SQL SELECTpgpro_version() INTO :ver;`
`6473`	`6473`	`EXEC SQL DISCONNECT;`
`6474`	`6474`
`6475`	`6475`	`printf("version: %s\n", ver);`
`6476`	`6476`
`6477`	`6477`	`EXEC SQL CONNECT TO :connection USER :user;`
`6478`		`- EXEC SQL SELECTversion() INTO :ver;`
	`6478`	`+ EXEC SQL SELECTpgpro_version() INTO :ver;`
`6479`	`6479`	`EXEC SQL DISCONNECT;`
`6480`	`6480`
`6481`	`6481`	`printf("version: %s\n", ver);`
`@@ -6651,14 +6651,14 @@ DECLARE <replaceable class="PARAMETER">cursor_name</replaceable> [ BINARY ] [ IN`
`6651`	`6651`	`<programlisting>`
`6652`	`6652`	`EXEC SQL DECLARE C CURSOR FOR SELECT * FROM My_Table;`
`6653`	`6653`	`EXEC SQL DECLARE C CURSOR FOR SELECT Item1 FROM T;`
`6654`		`-EXEC SQL DECLARE cur1 CURSOR FOR SELECTversion();`
	`6654`	`+EXEC SQL DECLARE cur1 CURSOR FOR SELECTpgpro_version();`
`6655`	`6655`	`</programlisting>`
`6656`	`6656`	`</para>`
`6657`	`6657`
`6658`	`6658`	`<para>`
`6659`	`6659`	`An example declaring a cursor for a prepared statement:`
`6660`	`6660`	`<programlisting>`
`6661`		`-EXEC SQL PREPARE stmt1 AS SELECTversion();`
	`6661`	`+EXEC SQL PREPARE stmt1 AS SELECTpgpro_version();`
`6662`	`6662`	`EXEC SQL DECLARE cur1 CURSOR FOR stmt1;`
`6663`	`6663`	`</programlisting>`
`6664`	`6664`	`</para>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -220,7 +220,7 @@`
`220`	`220`	`<listitem>`
`221`	`221`	`<para>`
`222`	`222`	`The <productname>&productname;</productname> version. You can run the command`
`223`		`- <literal>SELECTversion();</literal> to`
	`223`	`+ <literal>SELECTpgpro_version();</literal> to`
`224`	`224`	`find out the version of the server you are connected to. Most executable`
`225`	`225`	`programs also support a <option>--version</option> option; at least`
`226`	`226`	`<literal>postgres --version</literal> and <literal>psql --version</literal>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -360,7 +360,7 @@ mydb=#`
`360`	`360`	`commands:`
`361`	`361`	`<indexterm><primary>version</primary></indexterm>`
`362`	`362`	`<screen>`
`363`		`-<prompt>mydb=></prompt> <userinput>SELECTversion();</userinput>`
	`363`	`+<prompt>mydb=></prompt> <userinput>SELECTpgpro_version();</userinput>`
`364`	`364`	`version`
`365`	`365`	`------------------------------------------------------------------------------------------`
`366`	`366`	`&productname; &version; on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit`

Comments

(0)