Comment 1965 added to page xfunc-sql.html of version 7.4 - Mailing list pgsql-www

From nobody
Subject Comment 1965 added to page xfunc-sql.html of version 7.4
Date
Msg-id 200501051558.j05FwkQC026983@developer.pgadmin.org
Whole thread Raw
List pgsql-www
Author: Andrew Droffner <adroffne@advance.net>
----
In response to "There is no way to use a table_name as argument.",
programmers need to know that in Query-Language functions, the SQL  is PREPARED. It must follow the rules of prepared
statements.

Prepared statements must have explit DB objects (e.g. tables). They can only use variables in WHERE, INSERT-VALUES, or
UPDATE-assignments.

See the PostgreSQL PREPARE and EXECUTE statements.

Also, look up prepared statements in a general SQL textbook.
----
Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/xfunc-sql.html
Reject:      http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1965
Edit:        http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1965
Delete:      http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1965


pgsql-www by date:

Previous
From: Robert Treat
Date:
Subject: Re: "current" interactive docs busted
Next
From: Tom Lane
Date:
Subject: Re: "current" interactive docs busted