Some rare questions

From: Havasvölgyi Ottó <h(dot)otto(at)freemail(dot)hu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Some rare questions
Date: 2005-12-05 01:45:34
Message-ID: 007a01c5f93d$955ba660$0200a8c0@OTTO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am writing a driver for PostgreSQL, and I need some rare info:

How can I query the collation/locale of the database cluster?

What can be the maximal length of the indexed part of the string. So I have
a text field, and I create an index on it. How long can be one index key max
in this case?

How deep can be the subquery nesting?

How long can be the index key?

What is maximal number of compare operations for a single query?

What is maximal length of a query text (characters) ?

What is maximal length of a row (bytes) ?

What is the maximal length of char/varchar/text ?

What operations cannot be rolled back with Rollback ?

Thanks in advance,
Otto

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2005-12-05 02:05:51 Re: Selecting Large Object and TOAST
Previous Message Anton Nikiforov 2005-12-05 01:36:28 Re: int to inet conversion