|
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); |
|