PostgreSQL and array

banita · Post by **banita** » Sat 15 Aug 2009 22:31

I hava table with integer array field.
How can I do query like this:

select tab[1:3] from xxx;

?

I set ParamCheck on false but TUniQUery always interpret '3' like a param.

sory for my english.

Plash · Post by **Plash** » Tue 18 Aug 2009 06:59

Try to add a space after ':'

Code: Select all

select tab[1 : 3] from xxx

banita · Post by **banita** » Tue 18 Aug 2009 11:47

Unfortunately I get error:
"syntax error at or near 3"

When I try this query in PgAdmin all works fine.
strange...

Plash · Post by **Plash** » Wed 19 Aug 2009 07:43

We will add support for executing such query with spaces in the next build of PgDAC.