Page 1 of 1

PostgreSQL and array

Posted: Sat 15 Aug 2009 22:31
by banita
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.

Posted: Tue 18 Aug 2009 06:59
by Plash
Try to add a space after ':'

Code: Select all

select tab[1 : 3] from xxx

Posted: Tue 18 Aug 2009 11:47
by banita
Unfortunately I get error:
"syntax error at or near 3"

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

Posted: Wed 19 Aug 2009 07:43
by Plash
We will add support for executing such query with spaces in the next build of PgDAC.