Examples of using Pgsql in English and their translations into Chinese
{-}
-
Political
-
Ecclesiastic
-
Programming
PL/pgSQL is a block-structured language.
There are two types of comments in PL/pgSQL.
PL/pgSQL has a validator function, so we declare that too:.
The solution is to useEXECUTE for temporary table access in PL/PgSQL.
PL/PGSQL: this is PostgreSQL's native procedural language.
Example 35-1 shows how the manual installationprocedure would work with the language PL/pgSQL.
The design goals of PL/pgSQL were to create a loadable procedural language that.
The following command tells the database serverwhere to find the shared object for the PL/pgSQL language's call handler function.
The design goals of PL/pgSQL were to create a loadable procedural language that.
Except for input/output conversion and calculation functions for user-defined types, anything that can be defined in C language functionscan also be done with PL/pgSQL.
To declare foreign keys in PGSQL, there are few points which user should bear in mind:.
PL/pgSQL is a loadable procedural language for the PostgreSQL database system.
On the stored procedure side,we are planning to support Perl, pgSQL, Tcl, and JavaScript(via the V8 JavaScript engine).
Also, with PL/pgSQL you can use all the data types, operators and functions of SQL.
In a default PostgreSQL installation, the handler for the PL/pgSQL language is built and installed into the"library" directory.
Finally, a PL/pgSQL function can be declared to return void if it has no useful return value.
PL/pgSQL functions may also be declared to accept and return the polymorphic types anyelement and anyarray.
The instruction tree fully translates the PL/pgSQL statement structure, but individual SQL expressions and SQL commands used in the function are not translated immediately.
PL/pgSQL functions can also be declared with output parameters in place of an explicit specification of the return type.
When the return type of a PL/pgSQL function is declared as a polymorphic type(anyelement or anyarray), a special parameter $0 is created.
(Note that PL/pgSQL does not recognize warning, as opposed to error, condition names; those are classes 00, 01, and 02.).
(Note that PL/pgSQL does not recognize warning, as opposed to error, condition names; those are classes 00, 01, and 02.).
(Note that PL/pgSQL does not recognize warning, as opposed to error, condition names; those are classes 00, 01, and 02.).
The PL/pgSQL condition name for each error code is the same as the phrase shown in the table, with underscores substituted for spaces.
The pgsql extension now supports asynchronous connections and queries, thereby enabling non-blocking behaviour when interacting with PostgreSQL databases.