Postgres Pro
Downloads
Home   >   mailing lists

Re: query from a list of ids - Mailing list pgsql-general

From Listmail
Subject Re: query from a list of ids
Date
Msg-id op.trbwqpk9zcizji@apollo13
Whole thread Raw
In response to Re: query from a list of ids  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 

>> 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...

pgsql-general by date:

Previous
From: Listmail
Date:
Subject: Bitmap Scan Pages
Next
From: tom
Date:
Subject: Re: understanding output from Explain