How can we implement procedure cache? Cane you please give details regarding
this?
It will be helpful for me.
Thanks and regards,
CPK
On Fri, Nov 26, 2010 at 11:53 PM, Martin Gainty wrote:
> depends on the configuration implemented to enable caching
> capability for each type
> *usually* faste
Hey Craig,
I know about libpqxx. But I like to implement my library
just for fun :-).
The one goal of my library is to support all features of libpq.
So, I don't intent to implement the protocol from scratch
and use libpq as basis.
Another goal of my library is to be very clean and consistent
in
I'm having this 'issue':
coches=# select array_agg(patente order by fecha desc) from
dia4.infraccion limit 6;
array_agg
---
-
Le 27/11/2010 13:59, Emanuel Calvo Franco a écrit :
> I'm having this 'issue':
>
> coches=# select array_agg(patente order by fecha desc) from
> dia4.infraccion limit 6;
>
>array_agg
>
> -
Hello
probably you want
select array_agg(patente) from (select patente from dia4.infaccion
ORDER BY fecha DESC LIMIT 6) x
Regards
Pavel
2010/11/27 Emanuel Calvo Franco :
> I'm having this 'issue':
>
> coches=# select array_agg(patente order by fecha desc) from
> dia4.infraccion limit 6;
>
>
On 26 Nov 2010, at 6:04, Leif Jensen wrote:
Looking at your query, I'm kind of wondering why you're not letting the
database do the time-zone calculations?
But, that's not what your question was about:
> I have concentrate my effort on the (double) 'Seq Scan':
>
>
Emanuel Calvo Franco wrote:
I'm having this 'issue':
coches=# select array_agg(patente order by fecha desc) from
dia4.infraccion limit 6;
array_agg
--
2010/11/27 Lew :
> Emanuel Calvo Franco wrote:
>>
>> I'm having this 'issue':
>>
>> coches=# select array_agg(patente order by fecha desc) from
>> dia4.infraccion limit 6;
>>
>> array_agg
>> --
>>
Hi,
I want to access part of a table on the disk sequentially, i,e., when I get to
a tuple in the table, I need to read several pages of data in the table
starting from this tuple. I guess CTID could be translated to physical address
on the disk to retrieve this tuple, right? If so, how do I us
