What version of postgres are you using? I am using PostgreSQL 7.3b1 on
i686-pc-linux-gnu, compiled by GCC 2.96 and when I execute the following
statement:
select '{124,567,66}'::int[] + 345;
I get the error:
ERROR: cache lookup failed for type 0
Any ideas?
Thanks for your help!
-r
---
This is excellent! Thanks so much!
-r
On Tue, 2002-10-22 at 04:07, Teodor Sigaev wrote:
> regression=# select '{124,567,66}'::int[] + 345;
> ?column?
> --
> {124,567,66,345}
> (1 row)
> regression=# select '{124,567,66}'::int[] + '{345,1}'::int[];
>?column?
>
regression=# select '{124,567,66}'::int[] + 345;
?column?
--
{124,567,66,345}
(1 row)
regression=# select '{124,567,66}'::int[] + '{345,1}'::int[];
?column?
{124,567,66,345,1}
(1 row)
select '{124,567,66}'::int[] - 567;
?column?
--
{124,66
Hi Oleg (and pgsql hackers!),
Recently I encountered a problem attempting to use the integer array
function for pushing an integer onto an integer array field.
Can you write an example of a sql statement for pushing a single value onto
an integer array and for popping a specific value off of an i
