Hello list,
I don't know if it's me, or maybe even the way I designed these
dependencies, but I'm getting unexpected results when i query a specific
view.
I can only reproduce the unexpected results with a very specific set of
tables, views, and relationships.
The bad results are only manif
Hey Steve,
2010/9/11 Steve
> Hello list,
>
> I would like to call a function from my C application by using libpq and
> PQexecParams. My problem is that I don't know how to specify that I want to
> send an array to the function.
>
> Assume the function is called lookup_data and takes the followi
"Steve" writes:
>> Von: Tom Lane
>> It's unlikely to make enough difference to be worth the trouble.
>>
> Making a quick sort is ultra easy in C. Anyway... is there a
> difference in the speed of the query with pre-sorted values or not?
> If there is one then I will go and sort the values.
I di
Original-Nachricht
> Datum: Sat, 11 Sep 2010 11:04:16 -0400
> Von: Tom Lane
> An: "Steve"
> CC: pgsql-sql@postgresql.org
> Betreff: Re: [SQL] Question regarding indices
> "Steve" writes:
> > I have a small question about the order of values in a query. Assume I
> have a table
Original-Nachricht
> Datum: Sat, 11 Sep 2010 10:05:18 -0400
> Von: Michael Gould
> An: Steve
> Betreff: Re: [SQL] Question regarding indices
> Steve,
>
Hello Michael,
> If I remember correctly the sort only works on the final result set and so
> doing a sort before the sele
"Steve" writes:
> I have a small question about the order of values in a query. Assume I have a
> table with the following fields:
> uid INT,
> data BIGINT,
> hits INT
> And an unique index on (uid, data). I use libpq C API to query data from the
> table. The query is something like this:
Hello list,
I would like to call a function from my C application by using libpq and
PQexecParams. My problem is that I don't know how to specify that I want to
send an array to the function.
Assume the function is called lookup_data and takes the following parameters:
lookup_data(integer,inte
Hello List,
I have a small question about the order of values in a query. Assume I have a
table with the following fields:
uid INT,
data BIGINT,
hits INT
And an unique index on (uid, data). I use libpq C API to query data from the
table. The query is something like this:
SELECT uid,data,h
