From: | owner <ivan(at)psycho(dot)pl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | |
Date: | 2003-02-19 08:05:10 |
Message-ID: | Pine.LNX.4.44.0302190903550.27253-100000@rex.anfa.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi, i have some question and propos.
1. how can i get count of result's rows where i declare cursor ??
i need it to declare momeory , but i dont know how ...
2. I sometime select look like for example select 123 as "Foo 3" , 456 as
"Foo 4 ... ", and writing where is fanny.. in select should be somthing
like [] what == name of col. select would look : "select 232 as "QWE RTYU"
where [1] LIKE 'QWE%'; like in C or C++ or in any other lang.
3. Good thing will be to have somthing like suid in functions. When I do
select some_func ('arg1', 2 ,3 ) ; function should read table, and all
object like owner of this function. Most select do my functions, from many
tabels, and somtimes i have to give some person access to db and tables,
bo i want not give them all tables but only special rows, and it will be
good for just function with suid .. can you understand me ? :)
Also can be function to get user id, or name, and ip etc ...
4. Is possible to bring pg_hba.conf to db , in to pg_* tables ??
Maybe some of this tinks has been writen already but i dont know about it
, or maybe i should write it self ?
if someone can help me and tell me something about this thinks , please
mail to me ( ivan(at)psycho(dot)pl )
thx, sorry for my english :)
bye, ivan
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-02-19 08:11:12 | Re: techdocs broken again. |
Previous Message | Colin Mangiagalli | 2003-02-19 07:09:30 | Re: Transaction Logs Recycling Problem |