Comment 1965 added to page xfunc-sql.html of version 7.4

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

Browse pgsql-www by date

  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