Category Archives: Postgresql

Postgresql – Functions

Next i present to you one of my implementions of postgresql function usage. Generally postgresql functions should beĀ  something like stored procedures from MSSQL. From documenation you can see that the sintaxt is almost the same like MSSQL, but in my opinion it has more flexibility. I’ve tried to implement the insert, update, delete, select functions who will return a data table for C#. First you should create an table for testing purposes.

The function for insert is something like this:

For update the function looks like this:

For delete i use only a logical deleteĀ  using a flag. It can be modified in order to make …

Continue reading

Posted in Postgresql.