Re:

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Matthew Peter <survivedsushi(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re:
Date: 2006-01-09 22:14:22
Message-ID: c2d9e70e0601091414l49a202fdka6091d9cd2093db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/9/06, Matthew Peter <survivedsushi(at)yahoo(dot)com> wrote:
> is using IN to query a list of values in an function supported? or is there
> a work around for this type of query?
>
> e.g.
> ...
> SELECT * FROM tbl WHERE u_id IN (0$1)
>
> $$ LANGUAGE SQL;
>

if you mean
SELECT * FROM tbl WHERE u_id IN (0, 1)

then yes

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

  • at 2006-01-09 22:08:01 from Matthew Peter

Responses

  • Re: at 2006-01-09 23:26:45 from Matthew Peter

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Peter 2006-01-09 23:26:45 Re:
Previous Message Matthew Peter 2006-01-09 22:08:01