diff options
| author | Tom Lane | 2009-05-26 17:36:05 +0000 |
|---|---|---|
| committer | Tom Lane | 2009-05-26 17:36:05 +0000 |
| commit | 48938ab50686b98d2af4536bbf342a5011393815 (patch) | |
| tree | 1d2221d7c2af9c90f321e19b4a8a1e231b91c35e /doc/src | |
| parent | 99bf328237d89e0fd22821a940d4af0506353218 (diff) | |
Allow the second argument of pg_get_expr() to be just zero when deparsing
an expression that's not supposed to contain variables. Per discussion
with Gevik Babakhani, this eliminates the need for an ugly kluge (namely,
specifying some unrelated relation name). Remove one such kluge from
pg_dump.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index faf0e30b157..a594a12ed7b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.480 2009/05/18 08:59:29 petere Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.481 2009/05/26 17:36:05 tgl Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -12367,7 +12367,9 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); is a decompiled reconstruction, not the original text of the command.) <function>pg_get_expr</function> decompiles the internal form of an individual expression, such as the default value for a column. It can be - useful when examining the contents of system catalogs. + useful when examining the contents of system catalogs. If the expression + might contain Vars, specify the OID of the relation they refer to as the + second parameter; if no Vars are expected, zero is sufficient. <function>pg_get_viewdef</function> reconstructs the <command>SELECT</> query that defines a view. Most of these functions come in two variants, one of which can optionally <quote>pretty-print</> the result. The |