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
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.
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 have
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;
$$ LANGUAGE
Hilary Forbes [EMAIL PROTECTED] writes:
Next question on privileges!nbsp; 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
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
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 that
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
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
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