> I don't know what you mean by 'Stored Procedures', but PostgreSQL does
> support server run procedures in PL/SQL, tcl, C, perl and maybe others
that
> run inside the server, and can be called directly in SQL or can be called
as
> triggers. I've had a little look at it and it does look good.
A Stored Procedure is a microsoft thing, its a server side procedure that
can be cached for permformance reasons - heres an example:
CREATE PROCEDURE GetClientList
@Search varchar(10)
As
Select * From client Where cliname = @Search + '%'
At the moment its what sets microsoft apart from anything else, you can use
any TSQL in here so you can do server side cursors and even more complex
things. More and more windows programmers are using the features in mssql
espcially with the release of .NET. All we need is for postgres/mysql etc
to support this subset.
Kind Regards,
Chris Bond
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
