Search results for query: *

thank you very much, it can be done with the case clausule.

Sorry to bother you with Postgress problem in ANSI-SQL forum, but I didn't find any good postgress forum, so i hope someone here is able to help me. I have problem with with NULLs. My problem is as follows: I have for example this table: id | timestamps --------------- 1 | 9999343...

Yeah. It was a bug. According to PostgreSQL support, it is fixed in newer version.

it is impossible. it doesn't work for me even if i created the views as you did. what database are you using? i am using PostgreSQL 7 maybe it is an bug in PostgreSQL :)

I have different sulution, but i dont't know if this is usefull for you: select distinct (select avg(value) from tableA where id >= 1 and id <=10) as values_1_10, (select avg(value) from tableA where id >=11 and id <=20 ) as values_11_20, (select avg(value)...

thank you very much. but it doesn't work anyway. I will explain my problem form the beginning: table order_item id | name | state | order_id ---------------------------------- 20 | item1 | 1 | 1 21 | item2 | 1 | 1 23 | item3 | 2 | 1 24 | item1 | 1...

hi, thank you but it doesn't work for me result: id1 | count1 | count2 -----+--------+-------- 1 | 2 | 2 2 | 1 | 1 it is wrong, because column count2 shoudln't contain any 2's maybe an error in postgres :)

i have 2 views p1v,p2v select * from p1v; id1 | count1 -----+-------- 1 | 2 2 | 1 (2 rows) select * from p2v; id2 | count2 -----+-------- 1 | 1 2 | 1 (2 rows) is it possible to join views ? i have incorrect results(see bellow. 2's in the column count2 ) how...

i have 2 views p1v,p2v select * from p1v; id1 | count1 -----+-------- 1 | 2 2 | 1 (2 rows) select * from p2v; id2 | count2 -----+-------- 1 | 1 2 | 1 (2 rows) is it possible to join views ? i have incorrect results(see bellow. 2's in the column count2 ) how...

wow! thank you very much. is it possible to implement it in pg7? anyway thank you for your help.

i have four tables: Table 1.)info_firm ------------------------ id | name | class_id | ------------------------ 1 | CNN | 1000 | 2 | MTV | 1000 | 3 | Radio1 | 1001 | FK class_id references info_class(id) Table 2.)info_class ------------------- id | name |...