Hi,
I've got 3 tables: hosts (with host.id column) and reservation (with
reservation.id column) in many-to-many relation, and reservation_hosts
which is an association table (with reservation_id and host_id columns).
So I've got this query which selects hosts and reservations under
certain
Hi,
Do you need a MIN(start_date) for each host you get from the query
before last join?
Yes, I really do - the idea is that from several reservations fulfilling
the dates condition the earliest reservation has to be selected (i.e.
the one with minimum start date).
I edited your code
Hi,
What is the path format for the i (\i) command in the SQL shell?
I think it's just as anywhere else on Windows, e.g.
\i c:\path\to\file.sql
Windows support forward slashes as well, only not all Windows programs
do support that (cmd.exe for example doesn't). So, it's worth a try.
Hi,
This is my first attempt at using libpq, and I'm running across a strange
problem. Here is my bare-bones program:
#includestdio.h
#include libpq-fe.h
int main(int argc, char **argv) {
PGconn *conn;
fprintf(stderr, connecting\n);
conn = PQconnectdb(dbname=postgres);
Hi,
Looks like you accidently wrote to me personnally, not to mailing list.
On Wed, Feb 18, 2009 at 10:01 AM, Aurimas Černiusauri...@gmail.com wrote:
Did you use *exactly* the same command line to compile both versions?
What is that command line(s)?
Yes, I used the same compilation command
Hi,
Aurimas Černiusauri...@gmail.com wrote on Wed, Feb 18, 2009 at 06:08:07PM
+0200:
Libraries should be places after the source file, that is (not sure
about -L, but for -l surely):
gcc -o pq_test -IC:\Program Files\PostgreSQL\8.3\include pq_test.c
-LC:\Program Files\PostgreSQL\8.3\lib
