[SQL] maybe Offtopic : PostgreSQL & PHP ?

2001-04-18 Thread Picard, Cyril
Hi all, sorry for the maybe offtopic questions, but I did not get any answer from the PHP ML. I would like to query a postgresql db with the php language. Today I wrote a script (connectandquery.php) performing the following : - connect to the DB : $conn = pg_Connect("dbname = foo"); - execute t

RE: [SQL] outer joins

2001-04-04 Thread Picard, Cyril
I've read that the version 7.1 provides outer join feature. Since I did not try it yet, I've no more information about it. > -Message d'origine- > De: Algirdas Sakmanas [SMTP:[EMAIL PROTECTED]] > Date: mercredi 4 avril 2001 13:03 > À:[EMAIL PROTECTED] > Objet:[SQL] outer jo

RE: [SQL] passing null parameter to plpgsq functions

2001-04-03 Thread Picard, Cyril
Thank you ! I planned to use the 7.1 to get the outer join capability. Is the 7.1 stable ? > -Message d'origine- > De: Richard Huxton [SMTP:[EMAIL PROTECTED]] > Date: mardi 3 avril 2001 10:06 > À:Picard, Cyril; [EMAIL PROTECTED] > Objet:Re: [SQL] passi

[SQL] passing null parameter to plpgsq functions

2001-04-02 Thread Picard, Cyril
Hello I wrote a plpgsql function with few parameters ; when I call the function, some of the parameters can be null. In this case, all the parameters are considered as null in the function's body ! is it a feature ? how can I work around this ? Example : CREATE FUNCTION foo(text, text) RETURNS b