Skip to content

Commit 362a894

Browse files
committed
[Doc]: Replace SELECT version() by SELECT pgpro_version()
1 parent 5491b1d commit 362a894

File tree

3 files changed

+6
-6
lines changed

3 files changed

+6
-6
lines changed

doc/src/sgml/ecpg.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -6469,13 +6469,13 @@ EXEC SQL END DECLARE SECTION;
64696469
ECPGdebug(1, stderr);
64706470

64716471
EXEC SQL CONNECT TO :dbname USER :user;
6472-
EXEC SQL SELECT version() INTO :ver;
6472+
EXEC SQL SELECT pgpro_version() INTO :ver;
64736473
EXEC SQL DISCONNECT;
64746474

64756475
printf("version: %s\n", ver);
64766476

64776477
EXEC SQL CONNECT TO :connection USER :user;
6478-
EXEC SQL SELECT version() INTO :ver;
6478+
EXEC SQL SELECT pgpro_version() INTO :ver;
64796479
EXEC SQL DISCONNECT;
64806480

64816481
printf("version: %s\n", ver);
@@ -6651,14 +6651,14 @@ DECLARE <replaceable class="PARAMETER">cursor_name</replaceable> [ BINARY ] [ IN
66516651
<programlisting>
66526652
EXEC SQL DECLARE C CURSOR FOR SELECT * FROM My_Table;
66536653
EXEC SQL DECLARE C CURSOR FOR SELECT Item1 FROM T;
6654-
EXEC SQL DECLARE cur1 CURSOR FOR SELECT version();
6654+
EXEC SQL DECLARE cur1 CURSOR FOR SELECT pgpro_version();
66556655
</programlisting>
66566656
</para>
66576657

66586658
<para>
66596659
An example declaring a cursor for a prepared statement:
66606660
<programlisting>
6661-
EXEC SQL PREPARE stmt1 AS SELECT version();
6661+
EXEC SQL PREPARE stmt1 AS SELECT pgpro_version();
66626662
EXEC SQL DECLARE cur1 CURSOR FOR stmt1;
66636663
</programlisting>
66646664
</para>

doc/src/sgml/problems.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -220,7 +220,7 @@
220220
<listitem>
221221
<para>
222222
The <productname>&productname;</productname> version. You can run the command
223-
<literal>SELECT version();</literal> to
223+
<literal>SELECT pgpro_version();</literal> to
224224
find out the version of the server you are connected to. Most executable
225225
programs also support a <option>--version</option> option; at least
226226
<literal>postgres --version</literal> and <literal>psql --version</literal>

doc/src/sgml/start.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -360,7 +360,7 @@ mydb=#
360360
commands:
361361
<indexterm><primary>version</primary></indexterm>
362362
<screen>
363-
<prompt>mydb=&gt;</prompt> <userinput>SELECT version();</userinput>
363+
<prompt>mydb=&gt;</prompt> <userinput>SELECT pgpro_version();</userinput>
364364
version
365365
------------------------------------------------------------------------------------------
366366
&productname; &version; on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit

0 commit comments

Comments
 (0)