Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting string to IN query - Mailing list pgsql-general

From André Volpato
Subject Re: Converting string to IN query
Date
Msg-id 48CA7736.2050000@ecomtecnologia.com.br
Whole thread Raw
In response to Converting string to IN query  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Re: Autocommit, isolation level, and vacuum behavior
Next
From: Richard Huxton
Date:
Subject: Re: Converting string to IN query