Re: [GENERAL] Oracle to PSQL function

2007-03-29 Thread Pete
Hi Thanks for the help, but I am kind of stuck on the cursors in PL/pgSQL I have tried > adempiere.CUR_Attributes CURSOR ai.Value, a.Name FOR > SELECT ai.Value, a.Name and > DECLARE adempiere.CUR_Attributes CURSOR FOR > SELECT ai.Value, a.Name but none are accepted. >From t

Re: [GENERAL] Oracle to PSQL function

2007-03-29 Thread Tom Lane
Pete <[EMAIL PROTECTED]> writes: > I am looking for an on line help with loads of examples for PSQL > specifically in regards to stored procedures or functions. > The following does not help me much. > http://www.postgresql.org/docs/8.2/interactive/sql-createfunction.html Try http://www.postgresq

Re: [GENERAL] Oracle to PSQL function

2007-03-29 Thread Oisin Glynn
Pete wrote: Hi I am trying to do an upgrade on an open source app called adempiere The problem I have is that the original scripts are for Oracle and I am trying to run it on a PostgreSQLl data base I am having a problem converting the 007_ProductAttribute.sql script. See below I am getting

Re: [GENERAL] Oracle to PSQL function

2007-03-29 Thread David Fetter
On Thu, Mar 29, 2007 at 05:07:42PM +, Pete wrote: > > Hi > > I am trying to do an upgrade on an open source app called adempiere The > problem I have is that the > original scripts are for Oracle and I am trying to run it on a PostgreSQLl > data base > > I am having a problem converting

[GENERAL] Oracle to PSQL function

2007-03-29 Thread Pete
Hi I am trying to do an upgrade on an open source app called adempiere The problem I have is that the original scripts are for Oracle and I am trying to run it on a PostgreSQLl data base I am having a problem converting the 007_ProductAttribute.sql script. See below I am getting the followin