Fix for views that use AS with two words.

bmomjian · bmomjian · commit db82332bdcfd · 1998-07-09T14:59:27.000Z
diff --git a/src/backend/nodes/outfuncs.c b/src/backend/nodes/outfuncs.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/nodes/outfuncs.c,v 1.36 1998/06/15 19:28:32 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/nodes/outfuncs.c,v 1.37 1998/07/09 14:59:27 momjian Exp $
  *
  * NOTES
  *	  Every (plan) node in POSTGRES has an associated "out" routine which
@@ -660,7 +660,8 @@ _outResdom(StringInfo str, Resdom *node)
 	sprintf(buf, " :restypmod %d ", node->restypmod);
 	appendStringInfo(str, buf);
 	appendStringInfo(str, " :resname ");
-	appendStringInfo(str, node->resname);
+	sprintf(buf,"\"%s\"", node->resname); /* fix for SELECT col AS "my name" */
+	appendStringInfo(str, buf);
 	sprintf(buf, " :reskey %d ", node->reskey);
 	appendStringInfo(str, buf);
 	sprintf(buf, " :reskeyop %u ", node->reskeyop);
@@ -849,7 +850,7 @@ _outArray(StringInfo str, Array *node)
 	appendStringInfo(str, " :arraylow ");
 	for (i = 0; i < node->arrayndim; i++)
 	{
-		sprintf(buf, "  %d ", node->arraylow.indx[i]);
+		sprintf(buf, " %d ", node->arraylow.indx[i]);
 		appendStringInfo(str, buf);
 	}
 	appendStringInfo(str, " :arrayhigh ");

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/nodes/outfuncs.c,v 1.36 1998/06/15 19:28:32 momjian Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/nodes/outfuncs.c,v 1.37 1998/07/09 14:59:27 momjian Exp $`
`11`	`11`	`*`
`12`	`12`	`* NOTES`
`13`	`13`	`* Every (plan) node in POSTGRES has an associated "out" routine which`
`@@ -660,7 +660,8 @@ _outResdom(StringInfo str, Resdom *node)`
`660`	`660`	`sprintf(buf, " :restypmod %d ", node->restypmod);`
`661`	`661`	`appendStringInfo(str, buf);`
`662`	`662`	`appendStringInfo(str, " :resname ");`
`663`		`- appendStringInfo(str, node->resname);`
	`663`	`+ sprintf(buf,"\"%s\"", node->resname); /* fix for SELECT col AS "my name" */`
	`664`	`+ appendStringInfo(str, buf);`
`664`	`665`	`sprintf(buf, " :reskey %d ", node->reskey);`
`665`	`666`	`appendStringInfo(str, buf);`
`666`	`667`	`sprintf(buf, " :reskeyop %u ", node->reskeyop);`
`@@ -849,7 +850,7 @@ _outArray(StringInfo str, Array *node)`
`849`	`850`	`appendStringInfo(str, " :arraylow ");`
`850`	`851`	`for (i = 0; i < node->arrayndim; i++)`
`851`	`852`	`{`
`852`		`- sprintf(buf, " %d ", node->arraylow.indx[i]);`
	`853`	`+ sprintf(buf, " %d ", node->arraylow.indx[i]);`
`853`	`854`	`appendStringInfo(str, buf);`
`854`	`855`	`}`
`855`	`856`	`appendStringInfo(str, " :arrayhigh ");`