RES: [GENERAL] Conditioned access to a database

1999-02-11 Thread Ricardo J.C.Coelho
Olá Paulo, Como falamos a mesma língua, estou respondendo em Português. Veja o capítulo que fala sobre VIEWS e RULES. Você deve criar uma "view" para cada grupo selecionando apenas os registros que você quer permitir o acesso. Por exemplo: create view TABELA_GRUPOA as select * from TABELA wh

[GENERAL] Problems compiling

1999-02-11 Thread Jonathan Scott
Hello fellow PostgreSQL users.:) I am having trouble with the configure file for version 6.4.2. I have installed and configured and compiled it before without this problem. However this is a new machine with a wacked out debian install. Here is the output from my configure run: $ ./configure --

Re: [GENERAL] need help separating a field

1999-02-11 Thread Ross J. Reedstrom
Well, I once split up a bunch of multiline addresses with lines like this: select "PerIndex",substr("addr",1,(strpos("addr",'\n')- 1)) as addr, substr("addr",(str pos("addr",'\n')+1)) as addr2 into tmp2_addr from tmp_addr; so, try something like (untested): select substr(username_password,1,(s

Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-11 Thread Stephan Doliov
> Since we are tossing ideas around, here is my two cents. > .1c In order not to worry about royalties we can donate proceeds to > PostgreSQL. Amen/Bravo! This would truly be in the spirit of PostgreSQL Regarding the books contents. I think I. Section 1 - Intro 1. Brief Overview History 2. Ge

[GENERAL] need help separating a field

1999-02-11 Thread Kevin Heflin
I have a table with a field of 'username_password' where the data is in the format of: username/password what I would really like to do, is create a new field of 'username' and another of 'password' and with some magic SQL statement select all from username_password, and spit up the pair, and i

[GENERAL] Conditioned access to a database

1999-02-11 Thread Paulo da Silva
Hello, I'm evaluating sql/postgresql for the following purpose: I need to have a database with lots of "records". I need to allow groups of users to access sets of those records grouped by the contents of one field. For example, the group A can only access records that have the dptm field = "A".

Re: [GENERAL] Installer PostGres..

1999-02-11 Thread Stuart Rison
>Pour qu'on puisse t'aider, il faut que tu nous dise la version et le type de >systeme que tu >utilise pour etre sur d'aller au plus precis. Je crois aussi le mieux c'est >de s'exprimer en anglais >sur cette mailing liste car je n'ai encore jamais vu d'article en francais >:-) > Moi non plus mais

Re: [GENERAL] Installer PostGres..

1999-02-11 Thread Gilles Darold
Bonjour Sandrine, Ton probleme semble venir du fait que tu n'a pas installer le compilateur C++ sur ta machine. Ca n'a rien a voir avec le path, mais il est preferable aussi que tu renomme le repertoire /usr/src/pgsql/postgresql-6.4.2 en /usr/src/pgsql car la plupart des path par defaut pointent