diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2000-10-24 04:13:28 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2000-10-24 04:13:28 +0000 |
| commit | 4b70629b92185a3d5c5a39e224f38564d1e4fed6 (patch) | |
| tree | 43317745205337b2fda387e617ddfa401b043f1c | |
| parent | a9b6b01ee8a70d6abe8e5a56f18115c804fd10f4 (diff) | |
| download | postgresql-4b70629b92185a3d5c5a39e224f38564d1e4fed6.tar.gz postgresql-4b70629b92185a3d5c5a39e224f38564d1e4fed6.zip | |
Rejigger do_lo_list's query so that obj_description() is evaluated only
once per distinct LO, not once per pg_largeobject tuple.
| -rw-r--r-- | src/bin/psql/large_obj.c | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/src/bin/psql/large_obj.c b/src/bin/psql/large_obj.c index 5cfd18c328f..f97fab1a6c9 100644 --- a/src/bin/psql/large_obj.c +++ b/src/bin/psql/large_obj.c @@ -3,7 +3,7 @@ * * Copyright 2000 by PostgreSQL Global Development Group * - * $Header: /cvsroot/pgsql/src/bin/psql/large_obj.c,v 1.11 2000/10/24 01:38:39 tgl Exp $ + * $Header: /cvsroot/pgsql/src/bin/psql/large_obj.c,v 1.12 2000/10/24 04:13:28 tgl Exp $ */ #include "postgres.h" #include "large_obj.h" @@ -328,9 +328,8 @@ do_lo_list(void) printQueryOpt myopt = pset.popt; strcpy(buf, - "SELECT DISTINCT loid as \"ID\",\n" - " obj_description(loid) as \"Description\"\n" - "FROM pg_largeobject\n" + "SELECT loid as \"ID\", obj_description(loid) as \"Description\"\n" + "FROM (SELECT DISTINCT loid FROM pg_largeobject) x\n" "ORDER BY \"ID\""); res = PSQLexec(buf); |