Call a custom function that does what you asking and that returns the appropriate index value.
David J. On May 15, 2011, at 9:43, Daron Ryan <[email protected]> wrote: > 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? > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
