subject:"\[SQL\] Recursive SELECT problem"

Re: [SQL] Recursive SELECT problem

2006-05-17 Thread Tom Lane

Dave Page dpage@vale-housing.co.uk writes: I'm trying to write a query to determine whether or not the current login role has CREATEDB (or CREATEROLE) privileges, either directly or inherited from a parent role. Those privileges don't inherit, so I'm not sure why you need a recursive check.

Re: [SQL] Recursive SELECT problem

2006-05-17 Thread Dave Page

-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 17 May 2006 15:07 To: Dave Page Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Recursive SELECT problem Dave Page dpage@vale-housing.co.uk writes: I'm trying to write a query to determine whether