Re: Converting string to IN query

From: André Volpato <andre(dot)volpato(at)ecomtecnologia(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Converting string to IN query
Date: 2008-09-12 14:05:42
Message-ID: 48CA7736.2050000@ecomtecnologia.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrus escreveu:
> <snip>
> SELECT * FROM invoices WHERE invoiceno IN ( '1,3,4' );
>
> but this causes error.
> <snip>

change it to ( '1','3','4' ) or ( 1,3,4 )

--

ACV

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-09-12 15:04:18 Re: Converting string to IN query
Previous Message Andrus 2008-09-12 13:54:49 Re: Converting string to IN query