Re: [SQL] bug in information_schema?

2005-07-30 Thread Tom Lane
Kyle Bateman <[EMAIL PROTECTED]> writes: > I noticed that it seemed a bit slow to query > information_schema.view_column_usage. As I look at the code in > information_schema.sql, I'm not sure why pg_user is referenced twice > (once without an alias). It looks like we can take out the first >

Re: [SQL] How to loop though an array plpgsql?

2005-07-30 Thread Michael Fuhr
On Fri, Jul 29, 2005 at 03:39:12PM -0800, Matthew Schumacher wrote: > I need to loop though an input array, but can't figure out how to do it, > the docs aren't really clear on this. This comes up from time to time -- search the archives to see past discussion. Suggestions usually involve array_l