[GENERAL] postgres 7.4 array count

Hello. Is there any good solution to count elements from array field? Reg, Margusja ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] psql -U user -l cive all db list

Hey, For example, I have 10 postgres db created by postgres superuser postgres. when I login with postgres and do: psql -l I see all databases its OK. Now I create new user test_user and create new database with -O test_user - test_db. now I do under test_user: psql -U test_user -l and I see again

[GENERAL] is in postgres solution

Hello. I have 2 variables type timestamp. Example date1 = 2005-01-01 23:00 and date2 = 2005-05-04 12:00. I want get something like age(date2,date1) but ouput format must by hours::minutes. Is that bossible? Reg, Margusja ---(end of broadcast)--- TI