[GENERAL] thank you

Ya i got the answer here is the code SELECT * FROM (SELECT row_number() over(), * FROM employee) t1 right outer JOIN (SELECT row_number() over(), * FROM managers) t2 on t1.row_number=t2.row_number Thank you -- View this message in context: http://postgresql.1045698.n5.nabble.com/Here-is-my

Re: [GENERAL] need help

thanks for ur help,this was the requirement which assigned for us,so i had to ask even though we are having many options.thanks again -- View this message in context: http://postgresql.1045698.n5.nabble.com/Here-is-my-problem-tp5766954p5767778.html Sent from the PostgreSQL - general mailing

[GENERAL] need help

i have two unrelated tables as their is no common column to apply joins or anything, so i want to join those tables using simple query(only two tables should be used and no common table) can you pls help me out how to do that. I am new user to postgres this is table format table1

[GENERAL] Here is my problem

Now i want to insert data to the table the format should be id | marks -- 1 |50 1 |30 1 |30 2 |... the actual query is insert into table(id,marks) values(1,unnest(array[marks])) But we should not use array and unnest but i want in this format pls help.. -- V