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 <daron.r...@gmail.com> 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 (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
