[SQL] PostgreSQL downloads

2001-10-01 Thread Miguel González
Does anyone where there is a web site or ftp site where i can download the latest release of PostgreSQL? I have been trying to use the ftp://ftp.postgresql.org but it doesnt work properly. Many thanks in advance Miguel ---(end of broadcast)--- TI

[SQL] Creating a boolean function

2001-09-19 Thread Miguel González
by the way you know how to create the following sql function? I need to return a boolean saying if an object is onloan. the loan table is as follows: loans - code_loan code_user typetable i want to check these three fields, the first two fields (the code ones) are integer and the last a s

Re: [SQL] Registring a C function in PostgreSQL

2001-09-19 Thread Miguel González
quot;%s\" >/tmp/mailtmp.txt \n",VARDATA(message)); system(string_tosend); sprintf(string_tosend,"mail -s \"message from PostgreSQL\" %s To: "Miguel González" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, September 19, 2001 12:24

[SQL] Registring a C function in PostgreSQL

2001-09-18 Thread Miguel González
I have followed the instructions in the Bruje Momjian´s book to register afunction, and i got this message: ERROR:/load of file /home/postgres/ctof.so failed: /home/postgres/ctof.soELF file´s phentsize not the expected size.What is going on? I have tried to get more documentation about how

Re: [SQL] SQL Query

2001-09-12 Thread Miguel González
re and what the fields are. > > As a preliminary guess, it almost looks like you don't have fields in the > other tables to properly link thedata... but again I can't tell for sure. > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > http://www

[SQL] SQL Query

2001-09-11 Thread Miguel González
Dear all, I want to do a query to my PostgreSQL database. I want to use it in a PHP web client that I have got, but also I have tried in the back-end. I have the following tables on my database ( I translate the field names from Spanish into English) cdroms --- code_cdroms items -