Thread: functions
i'm not sure i fully understand functions..... i have created a query like select "book"."title" "author"."name" FROM ..... ..... WHERE "author"."name" = "J R Hartley"; and this returns TITLE Author Fly Fishing J R Hartley My Struggle J R Hartley etc... i assumed that i should easily be able to add this to a function and have the author name as a parameter. the advantagesi'm looking for are to keep all the sql in postgres and not in my java code and also to prevent postgres havingto compile the statement every time it is run. having looked at the documents and the o'reilly book i have been frustrated that all the examples about functions are fortrivial queries and not even google has helped me :( so are functions used in the way i want or have i missed something else? thanks. tom. -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup Get 4 DVDs for $.49 cents! plus shipping & processing. Click to join. http://oas-central.realmedia.com/RealMedia/ads/click_lx.ads/mail.com/columbiahouse/1112745096/x09/ExactAdv/ColumbiaHouse_IO473_7.19_8.19/blank.gif/636632633232383133383736634333430
