Michael Fuhr <[EMAIL PROTECTED]> writes:
> I don't know if there's an easier way to check if an int2 is a
> member of an int2vector, but you could write a function to convert
> an int2vector to an int2 array and then use an "= ANY" expression.
FWIW, as of 8.1 an int2vector *is* an int2 array, so =
On Thu, Sep 08, 2005 at 10:33:48PM +, Joÿffe3o Carvalho wrote:
> The problem here is to compare int2vector with int2.
Presumably you're talking about joining pg_index.indkey against
pg_attribute.attnum -- is that correct? Will pg_get_indexdef() not
work for your needs?
I don't know i
The problem here is to compare int2vector with int2.
Regards
João Carvalho
Michael Fuhr <[EMAIL PROTECTED]> escreveu:
[Please copy the mailing list on replies so others can contributeto and learn from the discussion.]On Thu, Sep 01, 2005 at 10:33:44PM -0300, João Carvalho wrote:> Michael Fuhr <[E
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Thu, Sep 01, 2005 at 10:33:44PM -0300, João Carvalho wrote:
> Michael Fuhr <[EMAIL PROTECTED]> escreveu:
> > http://www.postgresql.org/docs/8.0/static/monitoring.html
> > http://www.postgresql.o
On Fri, Sep 02, 2005 at 12:33:00AM +, Joÿffe3o Carvalho wrote:
> I want information about the following statistics:
> -List lock users
> -Show schema owners, it may also so more schema information
> -Check if a certain table has a toast table
See "Monitoring Database Activity" and "Sys
HiIm having problems doing some SQL queries.
I want information about the following statistics:-List lock users-Show schema owners, it may also so more schema information-Check if a certain table has a toast tableIf any one could help that would be very good.Regards_
