Thread: Fwd: [DOCS] Search bug
---------- Forwarded Message ---------- Subject: [DOCS] Search bug Date: Wednesday 17 August 2005 18:42 From: "Jim C. Nasby" <jnasby@pervasive.com> To: pgsql-docs@postgresql.org I know this might be more www than docs, but I'm not on that list... It appears that the search box uses % and _ as wildcards. This is fine (though we should make mention of it since people are probably more used to * and ? in search boxes, even if they are DBAs), but the problem is it doesn't seem to allow escaping them. For example, search on 'pg_stat_activity current_query'. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly ------------------------------------------------------- -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Try using double quotes. "pg_stat_activity" "current_query" ... John > -----Original Message----- > From: pgsql-www-owner@postgresql.org > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Robert Treat > Sent: Sunday, August 21, 2005 10:00 AM > To: pgsql-www@postgresql.org > Subject: [pgsql-www] Fwd: [DOCS] Search bug > > > > ---------- Forwarded Message ---------- > > Subject: [DOCS] Search bug > Date: Wednesday 17 August 2005 18:42 > From: "Jim C. Nasby" <jnasby@pervasive.com> > To: pgsql-docs@postgresql.org > > I know this might be more www than docs, but I'm not on that list... > > It appears that the search box uses % and _ as wildcards. > This is fine (though we should make mention of it since > people are probably more used to * and ? in search boxes, > even if they are DBAs), but the problem is it doesn't seem to > allow escaping them. For example, search on 'pg_stat_activity > current_query'. > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com 512-569-9461 > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org > so that your > message can get through to the mailing list cleanly > > ------------------------------------------------------- > > -- > Robert Treat > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > >
Hrm, thought I replied to this but maybe my cat ate it... ISTM it would be good to have either an advanced search or search help link that contained info about stuff like this. On Sun, Aug 21, 2005 at 02:34:34PM +1000, John Hansen wrote: > Try using double quotes. > > "pg_stat_activity" "current_query" > > ... John > > > -----Original Message----- > > From: pgsql-www-owner@postgresql.org > > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Robert Treat > > Sent: Sunday, August 21, 2005 10:00 AM > > To: pgsql-www@postgresql.org > > Subject: [pgsql-www] Fwd: [DOCS] Search bug > > > > > > > > ---------- Forwarded Message ---------- > > > > Subject: [DOCS] Search bug > > Date: Wednesday 17 August 2005 18:42 > > From: "Jim C. Nasby" <jnasby@pervasive.com> > > To: pgsql-docs@postgresql.org > > > > I know this might be more www than docs, but I'm not on that list... > > > > It appears that the search box uses % and _ as wildcards. > > This is fine (though we should make mention of it since > > people are probably more used to * and ? in search boxes, > > even if they are DBAs), but the problem is it doesn't seem to > > allow escaping them. For example, search on 'pg_stat_activity > > current_query'. > > -- > > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > > Pervasive Software http://pervasive.com 512-569-9461 > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org > > so that your > > message can get through to the mailing list cleanly > > > > ------------------------------------------------------- > > > > -- > > Robert Treat > > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 3: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com 512-569-9461
On Mon, 22 Aug 2005, Jim C. Nasby wrote: > ISTM it would be good to have either an advanced search or search help > link that contained info about stuff like this. > Another search issue that I've come across is that, for example, you can't search for posts about JDBC on the -general list. This is because every page has the list of lists on it. So you can't search for php, cygwin, odbc, jdbc, or pgadmin on any list. http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=jdbc&ul=http%3A%2F%2Farchives.postgresql.org%2Fpgsql-general%2F%25&dp=0&o=0&ps=10&s=date Kris
Kris Jurka Wrote > On Mon, 22 Aug 2005, Jim C. Nasby wrote: > > > ISTM it would be good to have either an advanced search or > search help > > link that contained info about stuff like this. > > > > Another search issue that I've come across is that, for > example, you can't search for posts about JDBC on the > -general list. This is because every page has the list of > lists on it. So you can't search for php, cygwin, odbc, > jdbc, or pgadmin on any list. Actually, that not entirely correct. The reason is that 'jdbc' is in the META KEYWORDS section. But yes, and advanced search page would be useful. In the meantime you can try typing 'body:(jdbc)' in the search box (without the quotes). > > http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st =20&dt=back&q=jdbc&ul=http%3A%2F%2Farchives.postgresql.org%> 2Fpgsql-general%2F%25&dp=0&o=0&ps=10&s=date > > Kris > > ... John