bryan@flyingiranch.com wrote:
> Next question: One of the reasons a function is attractive to me in this
> situation is that I also have some conditionals to handle. For instance,
> Base Metabolic Rate is different whether you are male or female (gender
> is a boolean value in my table). Can I use IF/THEN syntax in a view
> definition?
Take a look at the CASE conditional expression:
http://developer.postgresql.org/docs/postgres/functions-conditional.html
HTH,
Joe