[GENERAL] What am I doing wrong?

I'm in the single-slave scenario, with hot standby capabilities, meaning I want to run queries on the slave. I'm running some tests to evaluate pgbarman, on Ubuntu 11.10. I used only packaged PostgreSQL, and I'm running version "PostgreSQL 9.1.5 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real

Re: [GENERAL] what am I doing wrong with this query?

Never mind, I figured it out, I had to use ANY instead of IN, works fine now. Thanks, Tony ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that y

Re: [GENERAL] what am I doing wrong with this query?

Tony Caduto schrieb: > select array_to_string(conkey,',') from pg_constraint where contype = > 'p' and conrelid = 17059 > > returns a value of 1,2,18 for the array to string function, > > when I do this it does not return true: > > select case when 18 in (array_to_string(conkey,',')) then true

[GENERAL] what am I doing wrong with this query?

select array_to_string(conkey,',') from pg_constraint where contype = 'p' and conrelid = 17059 returns a value of 1,2,18 for the array to string function, when I do this it does not return true: select case when 18 in (array_to_string(conkey,',')) then true else false end from pg_constraint