Re: Unique Indexes - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Unique Indexes
Date
Msg-id 20050311183331.GA45696@winnie.fuhr.org
Whole thread Raw
In response to Unique Indexes  ("ILove TheSpam" <ilovethespam@hotmail.com>)
Responses Re: Unique Indexes  ("ILove TheSpam" <ilovethespam@hotmail.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Best practices: Handling Daylight-saving time
Next
From: Randall Nortman
Date:
Subject: Re: Best practices: Handling Daylight-saving time