Converting string to IN query
От | Andrus |
---|---|
Тема | Converting string to IN query |
Дата | |
Msg-id | gadqof$2845$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: Converting string to IN query
Re: Converting string to IN query Re: Converting string to IN query |
Список | pgsql-general |
String contains list of document numbers (integers) like: '1,3,4' How to SELECT documents whose numbers are contained in this string. I tried create temp table invoices ( invoiceno int ); insert into invoices values (1); insert into invoices values (2); insert into invoices values (3); insert into invoices values (4); SELECT * FROM invoices WHERE invoiceno IN ( '1,3,4' ); but this causes error. Numbers should be passed as single string literal since FYIReporting RDLEngine does not allow multivalue parameters. How to fix this so that query returns invoices whose numbers are contained in string literal ? Can arrays used to convert string to list or any other solution ? Andrus.
В списке pgsql-general по дате отправления: