Re: PostGreSql equivalents to mssql
От | Maksim Likharev |
---|---|
Тема | Re: PostGreSql equivalents to mssql |
Дата | |
Msg-id | 56510AAEF435D240958D1CE8C6B1770A014A0DAB@mailc03.aurigin.com обсуждение исходный текст |
Ответ на | PostGreSql equivalents to mssql ("adivi" <adivi@maximizelearning.com>) |
Список | pgsql-general |
Unfortunately I cannot tell you much about Postgres on Unix and client on Windows, but all my test apps written on VB and PG running on Linux, so this combination works and I think should not be much pain for you as well. Would be interesting to here real success story of happy marriage of postgres and ADO. -----Original Message----- From: adivi [mailto:adivi@maximizelearning.com] Sent: Sunday, July 06, 2003 10:41 PM To: Maksim Likharev Subject: Re: [GENERAL] PostGreSql equivalents to mssql thanks for the caution Maksim , but i do need to have my database on PostGreSql running on a unix/linux box. and i just need to have the application on Windows + .Net i can use odbc.net or inherit the adapter do you still see any possibility of serious issues !? please do let me know if i am headed in the wrong direction regards -adivi ----- Original Message ----- From: "Maksim Likharev" <mlikharev@aurigin.com> To: "adivi" <adivi@maximizelearning.com> Sent: Monday, July 07, 2003 10:58 AM Subject: RE: [GENERAL] PostGreSql equivalents to mssql So I would tell you, before doing something ask yourself what is you goal, if you shop primary OS is MS Windows and client is VB or .Net or more generally ADO 2.7.x you'll probably looking into wrong direction, because nothing works better with ADO then MS SQL Server. I am not telling you that postgres will not suite you, that will if you are following certain pattern. What is you goal? -----Original Message----- From: adivi [mailto:adivi@maximizelearning.com] Sent: Sunday, July 06, 2003 9:12 PM To: Maksim Likharev Subject: Re: [GENERAL] PostGreSql equivalents to mssql thanks for the reply: but Functions can do return Cursor ! can i parse them from a .Net application ? also i've found that PostGreSql 7.3 + can return recordset http://techdocs.postgresql.org/guides/SetReturningFunctions please reply if i can parse , using a .Net application or any such fromt end application, a.> cursors returned by a PostGreSql function b.> recordset ( multiple rows and columns ) returned by a PostGreSql function regards -adivi ----- Original Message ----- From: "Maksim Likharev" <mlikharev@aurigin.com> To: <mallah@trade-india.com>; <adivi@maximizelearning.com> Cc: <pgsql-general@postgresql.org> Sent: Sunday, July 06, 2003 12:28 PM Subject: RE: [GENERAL] PostGreSql equivalents to mssql > b.> return output parameters >I dont get this question very much, someone else might be >able to help u here. You cannot have [out] parameters in term of MS TSQL word, but your function could return a complex type, that will do a trick. Still you cannot return a recordset and [out] params, but do you need it?
В списке pgsql-general по дате отправления: