join from array or cursor - Mailing list pgsql-general

From John DeSoi
Subject join from array or cursor
Date
Msg-id A726A00E-857A-4B29-8AC5-BCDB8CB48B57@pgedit.com
Whole thread Raw
Responses Re: join from array or cursor  (Scott Bailey <artacus@comcast.net>)
Re: join from array or cursor  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Suppose I have an integer array (or cursor with one integer column)
which represents primary keys of some table. Is there a simple and
efficient way to return the rows of the table corresponding to the
primary key values and keep them in the same order as the array (or
cursor)? Seems like it should be easy, but I'm not seeing it.

Thanks,


John DeSoi, Ph.D.





pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: R: Field's position in Table
Next
From: Clemens Schwaighofer
Date:
Subject: Re: Postgre RAISE NOTICE and PHP