From: | nobody <nobody(at)developer(dot)pgadmin(dot)org> |
---|---|
To: | pgsql-www(at)postgresql(dot)org |
Subject: | Comment 1965 added to page xfunc-sql.html of version 7.4 |
Date: | 2005-01-05 15:58:46 |
Message-ID: | 200501051558.j05FwkQC026983@developer.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
Author: Andrew Droffner <adroffne(at)advance(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2005-01-05 16:46:32 | Re: Need to know final URLs for press kits |
Previous Message | Steve Simms | 2005-01-05 15:52:24 | Gborg down |