On Fri, Feb 6, 2009 at 1:11 AM, Stephan Szabo
wrote:
>
> On Thu, 5 Feb 2009, Michael B Allen wrote:
>
>> Please consider the following SQL
>>
>> SELECT e.eid, e.name
>> FROM entry e, access a
>> WHERE e.eid = 120
>> AND (e.ownid = 66 OR e.aid = a.aid)
>>
>> The intent is to match one entry
Zdravko Balorda wrote:
> this is probably an old issue but I'm not all that experienced.
>
> I wonder if an index can be accessed rather directly, as to speed up
> a query like "select count(distinct())", by simply calculating the
> number of branches (leaves) an index has. Or at least to skip sor
Hi,
this is probably an old issue but I'm not all that experienced.
I wonder if an index can be accessed rather directly, as to speed up
a query like "select count(distinct())", by simply calculating the
number of branches (leaves) an index has. Or at least to skip sorting.
Best regards, Zdr
This is a testplease disgregard.
This is a test, please disregard.
Just what I needed, thx!
-Oorspronkelijk bericht-
Van: pgsql-sql-ow...@postgresql.org namens A. Kretschmer
Verzonden: vr 6-2-2009 11:04
Aan: pgsql-sql@postgresql.org
Onderwerp: Re: [SQL] Data length and data precision
In response to Bart van Houdt :
> Hi all,
>
> I'm trying to write so
In response to Bart van Houdt :
> Hi all,
>
> I'm trying to write some code to make a 'fingerprint' of a database. This to
> compare a customer database with a reference database of our own.
> Therefore I'm trying to retrieve information like this:
> -Table name
> pg_class.relname where relkind
Hi all,
I'm trying to write some code to make a 'fingerprint' of a database. This to
compare a customer database with a reference database of our own.
Therefore I'm trying to retrieve information like this:
-Table name
pg_class.relname where relkind = 'r'
-Column name
pg_attribute where attre
