Hi all,
I've been using a procedure to make a copy of data in my public
schema into a history schema on UPDATE and INSERTs.
To prevent duplicate entries in the history, I have to lead in the
current data, compare it in my program and then decided whether
something has actually changed or
On Sat, Aug 15, 2009 at 01:41:12PM -0400, V S P wrote:
> but running into a problem as I cannot typecast correctly
>
> select V[i][j]
> FROM
> (select '{{A,B,C},{D,E,F}}') as V
> CROSS JOIN generate_series(1, 3) i
> CROSS JOIN generate_series(1,2) j
>
> Does not work, because V is not
Thank you very much , your suggestion
helped a lot
But, I have a bit more of a challenge now,
my array is being generated by the 'client' (it is not in the database)
so I am trying to employ your method on
'string'
but running into a problem as I cannot typecast correctly
s