Inserting / Selecting / Getting the Index. - Mailing list pgsql-general

From Daron Ryan
Subject Inserting / Selecting / Getting the Index.
Date
Msg-id 4DCFD883.1050601@gmail.com
Whole thread Raw
Responses Re: Inserting / Selecting / Getting the Index.  (David Johnston <polobo@yahoo.com>)
List pgsql-general
  I have a table with just 2 columns, 1 for a character array and one an
integer index. I need to process a string such as to find out the index
for it in the table if it is already there or insert it and then find
out it's index which is auto generated otherwise. Is there a way to do
this in a single step?

pgsql-general by date:

Previous
From: InterRob
Date:
Subject: Re: UNIQUE constraint on KEY VALUE PAIRS
Next
From: David Johnston
Date:
Subject: Re: Inserting / Selecting / Getting the Index.