Ed, There is big difference between PG's functions and Stored Procedures,
as they are commonly used.
PG's functions return a single value, Stored Procedures return a record set.
This will require some substantial changes to things like pg_tables, to
support what are effectively
'virtual tables'.
I don't know about the date formatting (although I
know that can always be done easily on the application
end, which is usually more convenient), but about the
regex:
They should work pretty much like perl (there may be a
few differences) except that you aren't retrieving
matches in PG or replaci
Michael,
I'm new to both PHP and PostgreSQL, and I had the same problem.
I fixed it by doing 2 things:
1) Requiring the database to be accessed by a username/passwd combination.
2) Connecting to the database with the username/passwd combination.
Here is my code:
(I put the hostname,
Michael Poon wrote:
>
> How can we do STORED PRECEDURE in PostgreSQL?
Several options exist (C, SQL, PL/pgSQL...). For starters, see CREATE
FUNCTION at
http://www.postgresql.org/docs/postgres/index.html
Cheers,
Ed Loehr
Hello,
I am looking for a tool which allows to use Postgres from a
Smalltalk environment.
Has everyone heard of it ?
Thank you for your answers.
Regards,
Christophe Touzéemail
: [EMAIL PROTECTED]
How can we do STORED PRECEDURE in PostgreSQL?
__
Get Your Private, Free Email at http://www.hotmail.com
I have just installed PHP on my new Cobalt RaQ3i, which came with
PostgreSQL already installed. Both PHP and PostgreSQL work
independently. I have created several sample databases using psql. My
test PHP scripts embedded in html work. But when I try to use PHP to
access a PostgreSQL all I
Hello Thomas,
I have used the same thing and it does work for me I was also getting
similar problems initially
What does your trigger do? does it insert a tuple back into the table? if
yes then that is your problem ... coz the insert will fire another trigger
and this may continue endles
I have created a trigger function.
could somebody tell me how I get the values from the insert in the trigger
function.
I tried the function
SPI_getvalue(trigger,tupdesc,attnum)
but after starting the trigger, I become this terminating output:
pqReadData() -- backend closed the channel unexpec
