Re: [GENERAL] How to update stavaluesN columns in pg_statistics (type anyarry)

2009-05-22 Thread Keith Hayden
2009/5/22 Keith Hayden > 2009/5/22 Tom Lane > > Keith Hayden writes: >> > I need to spoof statistics, and so need to update the stavaluesN columns >> in >> > pg_statistics, which are of type anyarray. Can this be done using an >> UPDATE >> &g

Re: [GENERAL] How to update stavaluesN columns in pg_statistics (type anyarry)

2009-05-22 Thread Keith Hayden
2009/5/22 Tom Lane > Keith Hayden writes: > > I need to spoof statistics, and so need to update the stavaluesN columns > in > > pg_statistics, which are of type anyarray. Can this be done using an > UPDATE > > statement ? I have tried using array[...] and '{...}

[GENERAL] How to update stavaluesN columns in pg_statistics (type anyarry)

2009-05-22 Thread Keith Hayden
Hi, I need to spoof statistics, and so need to update the stavaluesN columns in pg_statistics, which are of type anyarray. Can this be done using an UPDATE statement ? I have tried using array[...] and '{...}' syntax with no luck. Any other ideas as to how to achieve this ? Thanks, Keith.