Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Postgress problem
thank you very much, it can be done with the case clausule. -
Postgress problem
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... -
joining views
Yeah. It was a bug. According to PostgreSQL support, it is fixed in newer version. -
joining views
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 :) -
joining views
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... -
joining views
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 :) -
joining views
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... -
select problem (is it possible?)
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... -
select problem (is it possible?)
wow! thank you very much. is it possible to implement it in pg7? anyway thank you for your help. -
select problem (is it possible?)
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 |...
