staticvoidget_from_clause(Query*query,deparse_context*context);

staticvoidget_from_clause_item(Node*jtnode,Query*query,

deparse_context*context);

staticvoidget_from_clause_coldeflist(List*coldeflist,

deparse_context*context);

staticvoidget_opclass_name(Oidopclass,Oidactual_datatype,

StringInfobuf);

staticbooltleIsArrayAssign(TargetEntry*tle);

{

intvarno= ((RangeTblRef*)jtnode)->rtindex;

RangeTblEntry*rte=rt_fetch(varno,query->rtable);

List*coldeflist=NIL;

boolgavealias= false;

switch (rte->rtekind)

{

caseRTE_FUNCTION:

get_rule_expr(rte->funcexpr,context);

coldeflist=rte->coldeflist;

break;

default:

elog(ERROR,"unexpected rte kind %d", (int)rte->rtekind);

{

appendStringInfo(buf," %s",

quote_identifier(rte->alias->aliasname));

if (rte->alias->colnames!=NIL)

gavealias= true;

if (rte->alias->colnames!=NIL&&coldeflist==NIL)

{

List*col;

appendStringInfo(buf," %s",

quote_identifier(rte->eref->aliasname));

gavealias= true;

}

if (coldeflist!=NIL)

{

if (!gavealias)

appendStringInfo(buf," AS ");

get_from_clause_coldeflist(coldeflist,context);

}

}

elseif (IsA(jtnode,JoinExpr))

nodeTag(jtnode));

}

get_from_clause_coldeflist(List*coldeflist,deparse_context*context)

{

StringInfobuf=context->buf;

List*col;

inti=0;

appendStringInfoChar(buf,'(');

foreach(col,coldeflist)

{

ColumnDef*n=lfirst(col);

char*attname;

Oidatttypeid;

int32atttypmod;

attname=n->colname;

atttypeid=typenameTypeId(n->typename);

atttypmod=n->typename->typmod;

if (i>0)

appendStringInfo(buf,", ");

appendStringInfo(buf,"%s %s",

quote_identifier(attname),

format_type_with_typemod(atttypeid,atttypmod));

i++;

}

appendStringInfoChar(buf,')');

}

--------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

iexit | SELECT ih.name, ih.thepath, interpt_pp(ih.thepath, r.thepath) AS exit FROM ihighway ih, ramp r WHERE (ih.thepath ## r.thepath);

pg_indexes | SELECT n.nspname AS schemaname, c.relname AS tablename, i.relname AS indexname, pg_get_indexdef(i.oid) AS indexdef FROM (((pg_index x JOIN pg_class c ON ((c.oid = x.indrelid))) JOIN pg_class i ON ((i.oid = x.indexrelid))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE ((c.relkind = 'r'::"char") AND (i.relkind = 'i'::"char"));

pg_locks | SELECT l.relation, l."database", l.backendpid, l."mode", l.isgranted FROM pg_lock_status() l;

pg_locks | SELECT l.relation, l."database", l.backendpid, l."mode", l.isgranted FROM pg_lock_status() l(relation oid, "database" oid, backendpid integer, "mode" text, isgranted boolean);

pg_rules | SELECT n.nspname AS schemaname, c.relname AS tablename, r.rulename, pg_get_ruledef(r.oid) AS definition FROM ((pg_rewrite r JOIN pg_class c ON ((c.oid = r.ev_class))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE (r.rulename <> '_RETURN'::name);

pg_settings | SELECT a.name, a.setting FROM pg_show_all_settings() a;

pg_settings | SELECT a.name, a.setting FROM pg_show_all_settings() a(name text, setting text);

pg_stat_activity | SELECT d.oid AS datid, d.datname, pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_userid(s.backendid) AS usesysid, u.usename, pg_stat_get_backend_activity(s.backendid) AS current_query FROM pg_database d, (SELECT pg_stat_get_backend_idset() AS backendid) s, pg_shadow u WHERE ((pg_stat_get_backend_dbid(s.backendid) = d.oid) AND (pg_stat_get_backend_userid(s.backendid) = u.usesysid));

pg_stat_all_indexes | SELECT c.oid AS relid, i.oid AS indexrelid, n.nspname AS schemaname, c.relname, i.relname AS indexrelname, pg_stat_get_numscans(i.oid) AS idx_scan, pg_stat_get_tuples_returned(i.oid) AS idx_tup_read, pg_stat_get_tuples_fetched(i.oid) AS idx_tup_fetch FROM (((pg_class c JOIN pg_index x ON ((c.oid = x.indrelid))) JOIN pg_class i ON ((i.oid = x.indexrelid))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE (c.relkind = 'r'::"char");

pg_stat_all_tables | SELECT c.oid AS relid, n.nspname AS schemaname, c.relname, pg_stat_get_numscans(c.oid) AS seq_scan, pg_stat_get_tuples_returned(c.oid) AS seq_tup_read, sum(pg_stat_get_numscans(i.indexrelid)) AS idx_scan, sum(pg_stat_get_tuples_fetched(i.indexrelid)) AS idx_tup_fetch, pg_stat_get_tuples_inserted(c.oid) AS n_tup_ins, pg_stat_get_tuples_updated(c.oid) AS n_tup_upd, pg_stat_get_tuples_deleted(c.oid) AS n_tup_del FROM ((pg_class c LEFT JOIN pg_index i ON ((c.oid = i.indrelid))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE (c.relkind = 'r'::"char") GROUP BY c.oid, n.nspname, c.relname;