On 7/19/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
Q was incomplete. When i do a insert is there a way to know row already exists!!
what is the definition of "row already exists"? If you are concerned about a particular column, make that into a PK. If you are concerned about all the columns, make all the columns into a composite PK. Your program will croak accordingly. Else, just first do a SELECT before doing an INSERT. Use CONFLICT clause to handle conflicts. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ S&T Policy Fellow, National Academy of Sciences http://www.nas.edu/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------