On Sun, 2010-07-18 at 20:39 +0200, Dimitri Fontaine wrote:
> SHOW TABLE foo;
Yes
> SHOW TABLES WHERE tablename ~ 'foo';
>
> SHOW ANY TABLE
> GROUP BY tablename
> HAVING array_agg(attributes) @> array['date'::regtype,
> 'time'::regtype];
For me, realistically, No.
Simplifying SQL should be left to the SQL standards committee. It could
certainly use a hand there, but its too big a mountain too climb, for
me.
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Development, 24x7 Support, Training and Services