On Fri, Mar 11, 2005 at 04:21:49PM +0000, ILove TheSpam wrote:
> My problem is that I want to:
> a) Be able to detect when an error occurs and be able to read that error
> b) Find out the FieldID for the row which already has the value in it. So
> if I try to enter 'blah' into FieldValue and it's already in the row with
> FieldID=3, I want the value 3 to be returned to me. I realise this can be
> done using a SELECT after the error, but I'd like to avoid that. I'm hoping
> Postgres itself has some way of detecting this sort of thing.
Could you describe the problem you're trying to solve? It might
be easier to help if we knew the ultimate purpose of what you're
trying to do. Something like "I want to do this because...."
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/