Commit4b70629

committed

Rejigger do_lo_list's query so that obj_description() is evaluated only

once per distinct LO, not once per pg_largeobject tuple.

1 parenta9b6b01 commit4b70629Copy full SHA for 4b70629

File tree

-4

lines changed

-4

lines changed

Lines changed: 3 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`*`
`4`	`4`	`* Copyright 2000 by PostgreSQL Global Development Group`
`5`	`5`	`*`
`6`		`- * $Header: /cvsroot/pgsql/src/bin/psql/large_obj.c,v 1.11 2000/10/2401:38:39 tgl Exp $`
	`6`	`+ * $Header: /cvsroot/pgsql/src/bin/psql/large_obj.c,v 1.12 2000/10/2404:13:28 tgl Exp $`
`7`	`7`	`*/`
`8`	`8`	`#include"postgres.h"`
`9`	`9`	`#include"large_obj.h"`
`@@ -328,9 +328,8 @@ do_lo_list(void)`
`328`	`328`	`printQueryOptmyopt=pset.popt;`
`329`	`329`
`330`	`330`	`strcpy(buf,`
`331`		`-"SELECT DISTINCT loid as \"ID\",\n"`
`332`		`-" obj_description(loid) as \"Description\"\n"`
`333`		`-"FROM pg_largeobject\n"`
	`331`	`+"SELECT loid as \"ID\", obj_description(loid) as \"Description\"\n"`
	`332`	`+"FROM (SELECT DISTINCT loid FROM pg_largeobject) x\n"`
`334`	`333`	`"ORDER BY \"ID\"");`
`335`	`334`
`336`	`335`	`res=PSQLexec(buf);`

Comments

(0)