Hi!
I have 2 questions.
1. I want to store some data in database (8 different fields) and then
check some other thig and if something is ok i wan't to update some
data. I think i have to use function for this, because i don't want to
send so many queries over the net.
But now i'm confused. Is it ok if i use function with like 8 arguments
or is it better to insert data with normal INSERT query and then use
triger on INSERT wich calls some function to do all the work.
I would like someone to tell me more about this. Because document are
realy bad. Is it some great documents or book out in the net or book
store.
2. I have 3 SELECT queries
- SELECT id,name FROM users WHERE id = '40';
- SELECT id FROM users WHERE id > '40' ORDER BY id ASC LIMIT 1;
- SELECT id FROM users WHERE id < '40' ORDER BY id DESC LIMIT 1;
Now i want to create a function who wil execute al tree.
something like this
CREATE FUNCTION get_user(int4) RETURNS ?? AS '
..
..
..
' LANGUAGE = 'plpgsql'
I want output like this when i call this function ( SELECT
get_user('40');
id name idprev idnext
------------------------------
40 user1 35 42
id's are not one by one but its generated and stored as 23characters
(this 40 is just an example.)
What i want to know is how can i write that function and What should i
put after RETURNS and then how to return data.
Thanks for help
--
Uros