Re: [SQL] [PERFORM] Performance on writable views

od of overlap surrounding the time when you switch to a new partition), you're looking at evaluating every input query twice. In this case, the rules presumably are just simply re-directing DML, so there'd only be one rule in play at a time. That means the only real ov

Re: [SQL] Dynamic prepare possible in plpgsql?

;NULL')) in the dynamic statement. -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [SQL] [pgadmin-support] Groups and Roles and Users

PostgreSQL docs? Roles aren't pgAdmin specific, afterall. -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 9: In versions

Re: [HACKERS] [SQL] Case Preservation disregarding case

g that for output column names, /d, etc. get shot down? I thought it would be a useful addition... -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)

Re: [HACKERS] timestamp subtraction (was Re: [SQL] formatting intervals with to_char)

purposes. I agree it should be removed, but we might need a form of backwards compatibility for a version or two... -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcas