<rant>
Sheesh, and other bad words!
I am finding that typing in plpgsql is a HODGE PODGE.
Some places you HAVE to do it, so using the TYPE of the incoming data
is the only way to be flexible, like in Function arguments.
Some places you have to KNOW what type is coming in, like variables
declared IN a function, it doens't seem possible to use the type of an
external column as the type of a declared variable.
There's a couple of other places it's all screwy. I like posgres, but
it's kind of inconsistent and rigid at the same time.
It's be nice if types would silently convert, like in C and the 'm'
badword database.
</rant>
--
Carpe Dancem ;-)
-----------------------------------------------------------------
Remember your friends while they are alive
-----------------------------------------------------------------
Sincerely, Dennis Gearon