Re: [SQL] How can I simply substatue a value in a query?

hat it is. - I think a CASE statement is what you want. Check the Conditional Expressions section of the docs at: http://www.postgresql.org/docs/8.0/interactive/functions-conditional.html HTH, Bryan Encina ---(end of broadcast)--- TIP 4: Don'

Re: [SQL] Help on update that subselects other records in table, uses joins

>I suggest Joe Conway's "SQL for Smarties" or "SQL Queries for Mere Mortals" >from another author. I could be mistaken, but I'm pretty sure Josh means Joe Celko's "SQL for Smarties" as I've seen him mention it before, and not Joe Conway. -b ---(end of broadcast)---