Postgres Pro
Downloads
Home   >   mailing lists

Thread: Why PostgreSQL?

Why PostgreSQL?

From
Jignesh Shah
Date:
Hi,
 
Could anyone please tell me whats the difference between SQL and PostgreSQL?
 
Thanks,
Jignesh

Re: Why PostgreSQL?

From
Jignesh Shah
Date:
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


Re: Why PostgreSQL?

From
zbyszek
Date:
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

Re: Why PostgreSQL?

From
Serge Fonville
Date:
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



Re: Why PostgreSQL?

From
Jignesh Shah
Date:
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?
 
Thanks,
Jignesh

On Wed, Aug 19, 2009 at 3:01 PM, Serge Fonville <serge.fonville@gmail.com> wrote:
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




Re: Why PostgreSQL?

From
Sean Davis
Date:


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

Re: Why PostgreSQL?

From
Jignesh Shah
Date:
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?
 
Thanks,
Paresh

On Wed, Aug 19, 2009 at 4:15 PM, Sean Davis <sdavis2@mail.nih.gov> wrote:


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


Re: Why PostgreSQL?

From
Sean Davis
Date:


On Wed, Aug 19, 2009 at 6:52 AM, Jignesh Shah <jignesh.shah1980@gmail.com> wrote:
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?
 

If you know perl, then use perl.  Flexibility is just one of the joys of using Postgresql.  The PL/Perl chapter of the manual has a section devoted to triggers.

Sean