Обсуждение: Why PostgreSQL?

Jignesh Shah pisze:

> Hi,
>
> Could anyone please tell me whats the difference between SQL and PostgreSQL?
>
>
> Thanks,
> Jignesh
>
>

SQL is just language. Postgresql is database application which uses SQL
langauge to operate on data in database.

have a nice day,
Zbigniew Luszpinski

Sorry I meant SQL Server Database and SysBase also Object Relational Database Management system. Why I should use PostgreSQL over it?

 

Thanks,

Jignesh

On Wed, Aug 19, 2009 at 2:23 PM, zbyszek <zbiggy@o2.pl> wrote:

Jignesh Shah pisze:

> Hi,
>
> Could anyone please tell me whats the difference between SQL and PostgreSQL?
>
>
> Thanks,
> Jignesh
>
>

SQL is just language. Postgresql is database application which uses SQL
langauge to operate on data in database.

have a nice day,
Zbigniew Luszpinski

Hi,

Sorry I meant SQL Server Database and SysBase also Object Relational Database Management system. Why I should use PostgreSQL over it?

Have you googled, at all?

 

There are so many benefits of PostgreSQL over any other solution.

Too numerous to list them all.

 

Perhaps you can tell us what exactly you are intereseted in?

 

Regards,

 

Serge Fonville

 

 

Thanks,

Jignesh

On Wed, Aug 19, 2009 at 2:23 PM, zbyszek <zbiggy@o2.pl> wrote:

Jignesh Shah pisze:

> Hi,
>
> Could anyone please tell me whats the difference between SQL and PostgreSQL?
>
>
> Thanks,
> Jignesh
>
>

SQL is just language. Postgresql is database application which uses SQL
langauge to operate on data in database.

have a nice day,
Zbigniew Luszpinski

Yes, I googled but all have listed old differences. No links for latest differences. I want to write triggers in some specific language and want to process updated row using spi_prepare. It would be greate if you could provide example for that?

On Wed, Aug 19, 2009 at 6:36 AM, Jignesh Shah <jignesh.shah1980@gmail.com> wrote:

Yes, I googled but all have listed old differences. No links for latest differences. I want to write triggers in some specific language and want to process updated row using spi_prepare. It would be greate if you could provide example for that?

In postgres, functions can be written in at least perl, c, python, tcl, java, and pl/pgsql.  You'll probably want to look at the manual for writing functions and for triggers.  If you have problems writing a trigger to do what you want, perhaps you can post back with a test example and we can help. 

Sean

Thanks Sean. I just want to know which one is better approach to write trigger in PostgreSQL. PL/pgSQL or PL/Perl or PL/Tcl or PL/Python? I know Perl but not aware of Tcl and Python. Any method could replace any other method?