Dado,
> But still, the $1 is still plaguing me.
>
Here's your problem:
> >>CREATE FUNCTION new_proj_pts_seq(int4)
> >>RETURNS text
> >>AS 'DECLARE
> >> proj_ID alias for $1;
> >> seq_name TEXT;
> >> BEGIN
> >> seq_name := ''proj_pts_'' || proj_ID;
> >> create sequence seq_name;
> >> END;
> >> RETURNS seq_name;'
This should read: RETURN seq_name
No "S".
> >>LANGUAGE 'plpgsql';
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco