outlier_lynn (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
outlier_lynn) wrote2010-04-15 11:05 am
outlier_lynn) wrote2010-04-15 11:05 am
Entry tags:
Arrrrggg
I'm troubleshooting a pl/pgsql function that either inserts a new record, or, if it already exists, updates the record. Very straightforward. Except that it is not working.
I pass an xml document into this function and use xpath expressions to gather data needed in to determine row values for the insert or update. The result will be a couple of those values. The result is null and null.
FRUSTRATING.
Answer. Okay. If you declare "OUT" parameters; don't DECLARE them in the declaration block. Duh.
I pass an xml document into this function and use xpath expressions to gather data needed in to determine row values for the insert or update. The result will be a couple of those values. The result is null and null.
FRUSTRATING.
Answer. Okay. If you declare "OUT" parameters; don't DECLARE them in the declaration block. Duh.