Hi Joseph,
On Feb 1, 2004, at 7:40 PM, joseph speigle wrote:
> hi,
>
> I can't seem to find the comment for an sql file
>
> drop function dups();
> -- joe speigle
> -- Feb 1 2004
> CREATE FUNCTION dups() RETURNS int4
> AS 'SELECT 1 as RESULT' LANGUAGE 'sql';
it looks like you've got at least one extra pair of single quotes: you
don't need to quote sql.
test=# CREATE OR REPLACE FUNCTION dups() RETURNS int4
test-# AS 'SELECT 1 as RESULT' LANGUAGE SQL;
CREATE FUNCTION
test=# select * from dups();
dups
------
1
(1 row)
Hope that helps.
Michael Glaesemann
grzm myrealbox com