Bruno Wolff III wrote:
On Wed, Mar 31, 2004 at 12:30:58 -0500,
John DeSoi <[EMAIL PROTECTED]> wrote:
I want to have multiple groups A, B, C where each group could only see
a subset of a table (any number of groups would be possible). If a user
is a member of groups A and B then the rows they c
On Apr 2, 2004, at 10:39 AM, Bruno Wolff III wrote:
Except for SQL functions which can be inlined, the optimizer can't
optimize what is being done in the function with what is being done
in the select statement. This might be a performance issue depending
on your particular circumstances.
How does
On Thu, Apr 01, 2004 at 13:21:15 -0800,
Marc Durham <[EMAIL PROTECTED]> wrote:
> From: "John DeSoi" <[EMAIL PROTECTED]>
>
> Do you think this would work?
> There are a lot of joins. And I assumed it would need to look up the
> parent's and teacher's usernames, and that your many-to-many relatio
On Thu, Apr 01, 2004 at 22:50:48 -0500,
John DeSoi <[EMAIL PROTECTED]> wrote:
>
> Comments/criticisms about design or performance issues?
Except for SQL functions which can be inlined, the optimizer can't
optimize what is being done in the function with what is being done
in the select statemen
On 2/4/04 4:50 am, "John DeSoi" <[EMAIL PROTECTED]> wrote:
> Marc,
>
> On Apr 1, 2004, at 4:21 PM, Marc Durham wrote:
>
>> Do you think this would work?
>> There are a lot of joins. And I assumed it would need to look up the
>> parent's and teacher's usernames, and that your many-to-many
>> rel
Marc,
On Apr 1, 2004, at 4:21 PM, Marc Durham wrote:
Do you think this would work?
There are a lot of joins. And I assumed it would need to look up the
parent's and teacher's usernames, and that your many-to-many
relationships
were in tables like students_parent_link.
Thanks very much -- this
John DeSoi wrote:
I have a security model I have implemented in another (non-SQL) database
environment that I would like to use in Postgresql. I have read the
rules and set returning functions documentation but I still don't see
how it would work in Postgresql. Any ideas or direction would be g
I have a security model I have implemented in another (non-SQL)
database environment that I would like to use in Postgresql. I have
read the rules and set returning functions documentation but I still
don't see how it would work in Postgresql. Any ideas or direction would
be greatly appreciated
