View Single Post

   
  #2 (permalink)  
Old 04-09-2008, 10:17 AM
Szymic1
 
Posts: n/a
Default Re: Why my cursor construction is so slow?


> CREATE OR REPLACE FUNCTION alias(
> v_mask alias.mask%TYPE,
> ) RETURNS INT8 AS


Sorry my mistake it should be:

CREATE TABLE alias (
alias_id BIGSERIAL PRIMARY KEY,
mask VARCHAR(20) NOT NULL DEFAULT '',
);

Reply With Quote