On Sat, Apr 11, 2009 at 5:06 AM, Grzegorz Jaskiewicz <g...@pointblue.com.pl> wrote: > On 11 Apr 2009, at 08:01, Hitoshi Harada wrote: >> 2009/4/11 David Fetter <da...@fetter.org>: >>> On Sat, Apr 11, 2009 at 03:48:33PM +0900, Hitoshi Harada wrote: >>>> Yeah, but all the window functions are stored in pg_proc. >>> So are aggregate functions, and they have their own separate way of >>> being addressed in psql :) >> Aggregate functions are stored in pg_aggregate. And they are >> combinations of plain function which is stored in pg_proc. > Maybe trigger functions should be displayed separately too than ?
We're up to at least four different categories of functions that people think might require special treatment: window, trigger, I/O, everything else. And then there are other categories you might want to include/exclude: conversion functions, referential integrity functions, operator functions, ... it quickly gets out of control. Maybe we should consider some sort of option syntax for blackslash commands. Like, \df -w to see just window functions, \df -c to see just conversion functions, \df -wc to see those two types but not anything else. Actually, I don't really like that syntax either, because it's just propagating the existing dubious design decision of identifying the behavior you want with longer and longer strings of inscrutable single-digit modifiers. But some sort of more powerful syntax would be good. This problem is not limited to searching either - for example, I'd like to be able to do "\d foo, except don't show me the foreign-keys because there are a zillion of them and they make the output not fit on the screen". ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers