How to update stavaluesN columns in pg_statistics (type anyarry)

From: Keith Hayden <keith(dot)c(dot)hayden(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to update stavaluesN columns in pg_statistics (type anyarry)
Date: 2009-05-22 14:35:39
Message-ID: a69d82000905220735s16582864ia97c614ad7eed9ef@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-05-22 14:51:44 Re: question on serial key
Previous Message Sam Mason 2009-05-22 14:33:34 Re: question on serial key