[SQL] Where are the 7.1 RPM's?

Hello All, I have been using the 7.0.2 version of PostgreSQL which came with my Mandrake Linux and now want to do a fresh install of the 7.1 version because I think that there are many things fixed since then. Do anyone know where the 7.1 RPM's are so that I can install them? Cheers, Lonnie _

[SQL] g++ not working for postgresql extension languages?

Hi All again, One more thing that I have tried. If I now do a similar thing as in my previous message with the "funcs.c" file, but this time with the "funcs.cc" file then I can get: - [root@Treazurac /test]# g++ -I./include

[SQL] Simple Question

Hello All, This may be the wrong mailing list for this question but I hope someone can answer it for me as it is holding up my development progress. I have now been able to compile the tutorial/complex.c functions and test them out with no problems. I made a copy of the Makefile, Makefile.globa

Re: [SQL] Calling plSQL functions

Thanks for the code snippet Josh, I'll give this method a try as it is only for a simple listing and will not have to do too many things special. Cheers Lonnie --- Josh Berkus <[EMAIL PROTECTED]> wrote: > Lonnie, Tom: > > Here's a somewhat complicated example of what Tom's talking about from >

Re: [SQL] Calling plSQL functions

<[EMAIL PROTECTED]> wrote: > Lonnie Cumberland <[EMAIL PROTECTED]> writes: > > I have then created a PL/pgSQL function called "register_user()" in a file > > called register.sql > > > create function register_user(text,text,text,text,t

[SQL] Triggers on SELECT

Hello All, I have been reading on the uses of the Triggers from within the PL/pgSQL language and have seen that you can set up triggers for such things as UPDATE, and INSERT. I was just wondering why there was no trigger mechanicism for the SELECT statement? I could find some possible uses for

Re: [SQL] Calling plSQL functions

I solved the problem Josh. It had to do with the "select ..." statement in the function and also I needed to include a "record" variable so the the "select into " could act upon. Thanks for the help anyway. Cheers, Lonnie --- Josh Berkus <[EMAIL PROTECTED]> wrote: > Lonnie, > > It may be that

Re: [SQL] Calling plSQL functions

Hello Josh, Sorry for the bad terminology as I will try to get it corrected as I have a better learning of how to use postgresql properly. I will simply show you what I have done which should clarify things better. I have created a table "user_info" in a database "trdata" with a file called tab

[SQL] Calling plSQL functions

Hello All, I have created a plSQL function with the "create function ..." which seems to be ok and is just very simple. I then wanted to load the function by: psql -f test.sql -d trdata which loads my function fine. the problem is that I do not know how to call this function from the PLSQL in