Hi, Is there any reason why the grolist field in the table pg_group is implemented as an array and not as a separate table?
According to the documentation: <quote source="Postgresql 7.2 User Manual, chapter 6 near the end"> Arrays are not sets; using arrays in the manner described in the previous paragraph is often a sign of database misdesign. </quote> I have trouble implementing a way to easily check whether a user is part of a group. (I use Apache::AuthDBI to implement authentication and wanted to make a view with columns username, userid , groupname. And installing the contrib/array give's me a postgresql that is different from all the others :-( -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen [EMAIL PROTECTED] http://www.xs4all.nl/~reinoud __________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
