Re: [GENERAL] MS SQL - PostgreSQL

2005-09-15 Thread Klint Gore
On Thu, 15 Sep 2005 07:16:25 +0200, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > Am Donnerstag, den 15.09.2005, 07:43 +0700 schrieb Irfan Syukur: > > Dear Tino, > > > > In MS SQL, I can execute store procedure that I do not know it's name yet. > > > > A Simplicity example : > >CREATE proce

Re: [GENERAL] MS SQL - PostgreSQL

2005-09-14 Thread Tino Wildenhain
AntiSpam UOL schrieb: ANTISPAM UOL » TIRA-TEIMA Olá, Você enviou uma mensagem para [EMAIL PROTECTED] Para que sua mensagem seja encaminhada, por favor, *clique aqui* *snip* Esta confirmação é necessária porque [EMAIL PROTECTED] usa o Antispam UOL,

Re: [GENERAL] MS SQL - PostgreSQL

2005-09-14 Thread Tino Wildenhain
Am Donnerstag, den 15.09.2005, 07:43 +0700 schrieb Irfan Syukur: > Dear Tino, > > In MS SQL, I can execute store procedure that I do not know it's name yet. > > A Simplicity example : >CREATE procedure dbo.sp_run_batch (@as_spname varchar(20)) with > recompile as > >declare @li_rets

Re: [GENERAL] MS SQL - PostgreSQL

2005-09-14 Thread Tino Wildenhain
Am Donnerstag, den 15.09.2005, 07:43 +0700 schrieb Irfan Syukur: my Postfix reports: <[EMAIL PROTECTED]>: mail for bri.co.id loops back to myself this is weird. Your mail is apparently seriously broken. Please have that fixed. ---(end of broadcast)

Re: [GENERAL] MS SQL - PostgreSQL

2005-09-13 Thread Tino Wildenhain
Am Mittwoch, den 14.09.2005, 13:02 +0700 schrieb Irfan Syukur: > Dear Tino, > > Thanks for your answer. > > Can PostGreSQL handle dynamic 'stored procedure' whatever that means? :) Postgres stored functions are not fully equivalent to MSSQL stored procedures. Instead you use them just like regul

Re: [GENERAL] MS SQL - PostgreSQL

2005-09-13 Thread Dann Corbit
http://www.postgresql.org/docs/8.0/interactive/sql-createfunction.html > -Original Message- > From: Irfan Syukur [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 13, 2005 8:37 PM > To: Dann Corbit > Subject: RE: [GENERAL] MS SQL - PostgreSQL > > Dear Dann, >

Re: [GENERAL] MS SQL - PostgreSQL

2005-09-13 Thread Dann Corbit
) Subject: [GENERAL] MS SQL - PostgreSQL Dear Mailing List member, I have been using MS SQL for a few years and now I am trying to migrate to PostgreSQL. Are there any statements that similir for :    - if [not] exists (select 1 from sysdatabases where name=[db_name]) drop database [db_name

[GENERAL] MS SQL - PostgreSQL

2005-09-13 Thread Irfan Syukur
Title: MS SQL - PostgreSQL Dear Mailing List member, I have been using MS SQL for a few years and now I am trying to migrate to PostgreSQL. Are there any statements that similir for :    - if [not] exists (select 1 from sysdatabases where name=[db_name]) drop database [db_name]