BEGIN SELECT INTO count COUNT(DISTINCT person_id) FROM ( SELECT p.person_id FROM person_book AS p INNER JOIN (SELECT person_id FROM person_book where book_id=bookY) AS b ON p.person_id=b.person_id WHERE p.book_id=bookX ) al; RETURN "Books "||bookX||"and"||bookY||" have been purchased together by"||count||" people"; END; $BODY$ LANGUAGE plpgsql VOLATILE SECURITY DEFINER Example function call to test the function: SELECT joint_buyers_text(0, 9) as answer Result as presented in pgAdmin III: Task 2: In order to simplify the SQL query required for completion of the task a view has been created to store the list of IDs of all distinct books mentioned in data.txt CREATE OR REPLACE VIEW unique_books AS SELECT distinct book_id from person_book
ühtlaselt kogu juustele ja kujundada soeng. Sobib kasutamiseks nii kuivadele kui niisketele juustele. Gel Wax /flexible UV-filtriga B5 provitamiini sisaldav klassikaline juuksevaha, mis annab juustele painduva hoiaku ja struktuuri ilma, et need omavahel kokku kleepuksid. Tagab loomuliku sära. Kasutamine: Hõõruda väike kogus peopesade vahel soojaks ning kanda kõikjale juustes või ainult soovitud kohtadesse. Rõhutada sõrmi kasutades üksikuid salke või vormida kogu soeng. Curl Definer /strong Tugev geel vetruvate ja läikivate lokkide saavutamiseks. Toode sis aldab pro-vitamiini B5 ja UV-kaitset. Toode silub karedaid juukseotsi ning sisaldab kuumakaitset. Kasutamine: kanna toode niisketesse juustesse, seejärel föönita või lase vabalt õhu käes kuivada. Et saavutada lokkide perfektset eraldatust, kanna väike kogus kuivadele salkudele ja viimistle sõrmede abil. Hooldustooted Curl Energizer Shampoo
one decimal digit, via a system called binary-coded decimal. decrement Decreasing a numeric value, usually by 1. default A value automatically set by the PC when the user does not specifically set another value. Many devices will assume such default conditions upon the application of power. definer A number used as an operand for an instruction but that serves to define the instruction itself, rather that the data on which the instruction is to operate. Defin- ers include jump numbers, subroutine numbers, etc. destination The location where an instruction places the data on which it is operating, as
annaabi.ee 
