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
The best I can think of off the top of my head would still be multiple SQL,
but at least it would be in one transaction block:
BEGIN;
SELECT '1' AS ordering, t1.* INTO TEMP TABLE work_table FROM t1 WHERE t1.id
= '3';
SELECT '2' AS ordering, t1.* INTO TEMP TABLE work_table FROM t1 WHERE t1.id
= '2'
