## THE PROBLEM
I'm trying to write a function that will select the ID of a row from a very
large table (2M rows) using an index (places_autocomplete_idx).
When I execute the function the query stalls and is apparently not taking
advantage of the index. However, executing the same query outside
o
Hi ml!
A question about cidr query. I'm tring to use the various cidr functions
to exclude a A sub class, but I don't understand how use it:
SELECT count(ip_addr), ip_addr from wi_log_network where ip_addr !=
network('10.10.0.0/16', 16) group by (ip_addr);
it don't exclude the 10.10 ! Tried als
On Tue, 10 Jul 2007 09:36:49 +0200
Michele Petrazzo - Unipex srl <[EMAIL PROTECTED]> wrote:
> Hi ml!
>
> A question about cidr query. I'm tring to use the various cidr
> functions to exclude a A sub class, but I don't understand how use it:
>
> SELECT count(ip_addr), ip_addr from wi_log_network
On Tue, Jul 10, 2007 at 09:36:49AM +0200, Michele Petrazzo - Unipex srl wrote:
> A question about cidr query. I'm tring to use the various cidr functions
> to exclude a A sub class, but I don't understand how use it:
>
> SELECT count(ip_addr), ip_addr from wi_log_network where ip_addr !=
> network
Is there a way to query the database system identifier that pg_controldata
outputs from SQL?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://ww
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Is there a way to query the database system identifier that pg_controldata
> outputs from SQL?
Don't think so. Do you have a use-case for providing a function to
return that?
regards, tom lane
---(en
Patrick Clery <[EMAIL PROTECTED]> writes:
> When I execute the function the query stalls and is apparently not taking
> advantage of the index.
Your example doesn't demonstrate any such thing; what seems more likely
is that there are a whole lot of rows matching 'United States' and so
the query t
Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Is there a way to query the database system identifier that
> > pg_controldata outputs from SQL?
>
> Don't think so. Do you have a use-case for providing a function to
> return that?
I'd like to find out whether two connections ar
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Peter Eisentraut <[EMAIL PROTECTED]> writes:
>>> Is there a way to query the database system identifier that
>>> pg_controldata outputs from SQL?
>>
>> Don't think so. Do you have a use-case for providing a function to
>> return th
