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
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:
Steve stev...@gmx.net 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
Original-Nachricht
Datum: Sat, 11 Sep 2010 10:05:18 -0400
Von: Michael Gould mgo...@intermodalsoftwaresolutions.net
An: Steve stev...@gmx.net
Betreff: Re: [SQL] Question regarding indices
Steve,
Hello Michael,
If I remember correctly the sort only works on the
Original-Nachricht
Datum: Sat, 11 Sep 2010 11:04:16 -0400
Von: Tom Lane t...@sss.pgh.pa.us
An: Steve stev...@gmx.net
CC: pgsql-sql@postgresql.org
Betreff: Re: [SQL] Question regarding indices
Steve stev...@gmx.net writes:
I have a small question about the order
Steve stev...@gmx.net writes:
Von: Tom Lane t...@sss.pgh.pa.us
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
Hey Steve,
2010/9/11 Steve stev...@gmx.net
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
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