File tree Expand file tree Collapse file tree 3 files changed +6
-6
lines changed Expand file tree Collapse file tree 3 files changed +6
-6
lines changed 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 SELECT version () INTO :ver;
6472
+ EXEC SQL SELECT pgpro_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 SELECT version () INTO :ver;
6478
+ EXEC SQL SELECT pgpro_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 SELECT version ();
6654
+ EXEC SQL DECLARE cur1 CURSOR FOR SELECT pgpro_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 SELECT version ();
6661
+ EXEC SQL PREPARE stmt1 AS SELECT pgpro_version ();
6662
6662
EXEC SQL DECLARE cur1 CURSOR FOR stmt1;
6663
6663
</programlisting>
6664
6664
</para>
Original file line number Diff line number Diff line change 220
220
<listitem>
221
221
<para>
222
222
The <productname>&productname;</productname> version. You can run the command
223
- <literal>SELECT version ();</literal> to
223
+ <literal>SELECT pgpro_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>
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>SELECT version ();</userinput>
363
+ <prompt>mydb=></prompt> <userinput>SELECT pgpro_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
You can’t perform that action at this time.
0 commit comments