Re: oracle script to postgresql

FERREIRA William (COFRAMI) wrote:
> hi,
> 
> i'm trying to port an oracle script to postgresql, but i don't find
> any alternative for some problems this is an extract of the oracle
> script : 
> 
> DEFINE MDNSImportBlobDirectory =
> C:\Temp\_lm_\ExternalTablesSpace\mdns;
> @createFraweWorkTables_script.ddl; @createMDNSProcStockImport.sql
> &MDNSImportBlobDirectory; 
> 
> so i need to declare variables and to pass them to others script
> 
> is there any alternative for doing this ?

You can define variables in PG functions and pass them to other
functions:

DECLARE

   numRows integer := 5;

BEGIN

   perform add_5_min_table(numRows);

-- 
Guy Rouillier