|
Post by Ja Ona i Pivo on Mar 16, 2009 8:07:51 GMT -5
man i know its wrong thats why i ask u if u can write the right one Damn thoes it have to be so hard..
I have to create a view, if u can do it. Please post it here.. if u cant, well than we have nothing to discuss here.. Thnx for the help
|
|
Kralj Vatra
Amicus
Warning: Sometimes uses foul language & insults!!!
20%
Posts: 9,814
|
Post by Kralj Vatra on Mar 16, 2009 8:27:36 GMT -5
man i know its wrong thats why i ask u if u can write the right one Damn thoes it have to be so hard.. I have to create a view, if u can do it. Please post it here.. if u cant, well than we have nothing to discuss here.. Thnx for the help here is an example which works create view Personal as select namn,avdelning from Larare; however note that you can have theoretically infinite possible views out of this table... The above is just an example. e.g. create view Personal_old_people as select namn,avdelning from Larare where foddlarare <='1970-01-01'; create view Personal_young_people as select namn,avdelning from Larare where foddlarare >'1970-01-01'; postgres@2rm=# SELECT * from personal_old_people ; namn | avdelning ----------------------+----------- Mikael | APS Conny | APS Charlie | APS Birgitta | AIS Anders | APS Betty | APS postgres@2rm=# SELECT * from personal_young_people ; namn | avdelning ----------------------+----------- Mats-Ola | AIS Andreas | APS Marie | APS Linda | APS (4 rows) postgres@2rm=#
|
|
|
Post by Ja Ona i Pivo on Mar 16, 2009 9:16:52 GMT -5
Ah thanks mate... this is really a help.. EXALT
|
|
|
Post by zgembo on Mar 16, 2009 23:42:50 GMT -5
Serbs have only two friends: God and Pyrros.
|
|
|
Post by Ja Ona i Pivo on Mar 17, 2009 6:32:02 GMT -5
haha true
|
|
|
Post by Ja Ona i Pivo on Mar 17, 2009 10:13:16 GMT -5
AAdmin, u can delete this thread if u want. my problem is solved. thnx
|
|