At 8:01p -0400 on 26 Apr 2007, Steve Midgley wrote:
From that application, I want to retrieve all those rows, and I
want them in the order they are currently stored in that variable.
So take for example this foreign application variable:
ids = "3,2,5,1,4"
The application then executes thi
On 27/04/07, Aaron Bono <[EMAIL PROTECTED]> wrote:
On 4/26/07, Steve Midgley <[EMAIL PROTECTED]> wrote:
> So take
> for example this foreign application variable:
>
>ids = "3,2,5,1,4"
>
> The application then executes this sql:
>
>select * from table where id in (3,2,5,1,4)
>
> As-is, of
On 4/26/07, Steve Midgley <[EMAIL PROTECTED]> wrote:
So take
for example this foreign application variable:
ids = "3,2,5,1,4"
The application then executes this sql:
select * from table where id in (3,2,5,1,4)
As-is, of course, the above query will return the 5 records in a
semi-random
> them in the order they are currently stored in that variable. So take
>
> for example this foreign application variable:
>
>ids = "3,2,5,1,4"
kludgy, but:
1. store your ids in a pg array
2. select from the array
3. on order by, write a function that takes the row.id and array as
paramet
]
On Behalf Of Steve Midgley
Sent: Friday, 27 April 2007 10:01
To: pgsql-sql@postgresql.org
Subject: [SQL] Selecting rows with "static" ordering
Hello,
I have a strange problem (or one that I've never had before anyway). I
am searching for a list of "id's" for a given table
Hello,
I have a strange problem (or one that I've never had before anyway). I
am searching for a list of "id's" for a given table (these id values
are generated at run-time and held statically in an application-local
variable).
From that application, I want to retrieve all those rows, and I
