Re: PL/pgSQL examples NOT involving functions

>>>>> "Josh" == Josh Berkus <josh(at)agliodbs(dot)com> writes:

Josh> Personally, I find that keeping track, on the client side,
Josh> of whether you're adding a new record or editing an old one
Josh> and acting appropriately is better than trying to
Josh> second-guess it on the database level, but maybe that's just
Josh> me.

Well, that's basically what I'm trying to do. But finding out whether
I need to insert or update requires doing something like my pseudo-SQL
example. I was just trying to figure out if I could do in in SQL
pl/pgSQL.

roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375