ivan marchesini wrote:
Dear users
It's a simple problem I think (and I hope :-)
I have a table like this:
A|B|C
1|2|20
1|3|10
1|4|21
2|3|12
2|4|22
3|4|23
where the first two column are a combination without repetition (with
k=2) of the numbers 1,2,3,4
for each pair I have a value in the c
Tom
Thank you - I think that the underlying problem is that I was trying
out
REVOKE ALL FROM TABLE suppliers FOR public;
then connect as hilary and I can still see the table rows.
I appear to have to revoke each type eg
REVOKE SELECT FROM TABLE suppliers FOR public;
etc and then the code works.
Is
Dear All
Next question on privileges! Can I safely remove all privileges
from the system catalog tables for a user and still enable them to select
from the public schema? I guess the real question is what access
rights does an ordinary user have to have to the system catalog tables in
order for
On 7/21/06, Hilary Forbes <[EMAIL PROTECTED]> wrote:
Dear All
Next question on privileges! Can I safely remove all privileges
from the system catalog tables for a user and still enable them to select
from the public schema? I guess the real question is what access
rights does an ordinary user ha
Many thanks to Stephan, Richard and George. When I was reading the
documentation about FOR loops, I didn't realize that I was in the plpgsql
section!
CREATE OR REPLACE FUNCTION rgio() RETURNS integer as $$
BEGIN
DECLARE lv RECORD;
FOR lv IN SELECT DISTINCT rg FROM ldevrg LOOP
am 21.07.2006, um 9:26:21 -0600 mailte Kevin Nikiforuk folgendes:
> Many thanks to Stephan, Richard and George. When I was reading the
> documentation about FOR loops, I didn't realize that I was in the plpgsql
> section!
>
> CREATE OR REPLACE FUNCTION rgio() RETURNS integer as $$
> BEGIN
>
"Kevin Nikiforuk" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION rgio() RETURNS integer as $$
> BEGIN
> DECLARE lv RECORD;
> FOR lv IN SELECT DISTINCT rg FROM ldevrg LOOP
> SELECT ldev FROM ldevrg WHERE ldevrg='$lv';
> END LOOP;
> RETURN 1;
> END;
>
Hilary Forbes <[EMAIL PROTECTED]> writes:
> Next question on privileges! Can I safely remove all privileges
> from the system catalog tables for a user
Various people have experimented with doing that, but it tends to break
a lot of stuff. I suggest you just revoke privileges on the tables you
d
On Fri, 21 Jul 2006, Kevin Nikiforuk wrote:
> Many thanks to Stephan, Richard and George. When I was reading the
> documentation about FOR loops, I didn't realize that I was in the plpgsql
> section!
>
> CREATE OR REPLACE FUNCTION rgio() RETURNS integer as $$
> BEGIN
> DECLARE lv RECORD
Aaron
Thanks for this one - I had actually wondered about doing that but the
trouble is that they say that they need up to the minute reports not
"as of last night". Indeed, I do have another app where I
do just that because I find that reports indexes/requirements are very
different to transacti
On Fri, 2006-07-21 at 11:19, Hilary Forbes wrote:
> Aaron
>
> Thanks for this one - I had actually wondered about doing that but the
> trouble is that they say that they need up to the minute reports not
> "as of last night". Indeed, I do have another app where I do just
> that because I find tha
So now that I've got my loops working, on to my next newbie question. I've
created my function and in it, I want to loop through the results of a select
and for each value of my loop counter, I want to create a new table, but I
can't figure out how to use a variable in the name of the new table
On 7/21/06, Kevin Nikiforuk <[EMAIL PROTECTED]> wrote:
So now that I've got my loops working, on to my next newbie question. I've
created my function and in it, I want to loop through the results of a select
and for each value of my loop counter, I want to create a new table, but I
can't figu
Rodrigo De Leon wrote:
On 7/21/06, Kevin Nikiforuk <[EMAIL PROTECTED]> wrote:
So now that I've got my loops working, on to my next newbie
question. I've created my function and in it, I want to loop through
the results of a select and for each value of my loop counter, I want
to create a new
14 matches
Mail list logo
