Re: query from a list of ids

From: Listmail <lists(at)peufeu(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: query from a list of ids
Date: 2007-04-25 07:36:15
Message-ID: op.trbwqpk9zcizji@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> name| ids
>> -------------------------
>> Peter| 2, 3, 4, 5
>> Jack| 100, 34, 3
>>
>> Both name and ids are in text format.

IF you really do not want to use a link table (user_id, flag_id), you
could use an array of ints instead of a string...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tom 2007-04-25 10:06:07 Re: understanding output from Explain
Previous Message Listmail 2007-04-25 06:36:45 Bitmap Scan Pages