On Sat, Apr 07, 2007 at 10:33:19AM -0700, Karthikeyan Sundaram wrote: > I am using 8.1.0 postgres and trying to write a plpgsql block.
8.1.8 is the latest version in that branch. Read the Release Notes for each minor release to see what bug fixes you're missing. http://www.postgresql.org/docs/8.1/interactive/release.html > In that I am inserting a row. I want to check to see if the row > has been inserted or not. See "Obtaining the Result Status" and "Trapping Errors" in the PL/pgSQL documentation. http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
